0

My Application ( Vb.Net) is to scan Access DB forms and find out the Activx control if present and it works fine. But my problem is...

In some DBs we have tables with mapping path to specific locations (Table Property->Linked Table Manager) and when we relocate these DBs then we need to change the path manually otherwise it will show a message to re-link ( Access DB message) while opening the DB. And I am facing same problem while scanning through my Tool as well and my process stops, continue only by manual intervention.

Do I capture the massage event and send some user specific message to user in the Log file or Report and continue scanning further?

Can anyone help me???

Improve this question

1 Answer 1

Reset to default
0

I think this is caused by a startup macro that is checking the linked tables. You should disable startup forms and macros when opening the database.

To disable startup forms or autoexec - look here

how-do-i-bypass-ms-access-startup-when-using-ole

or

http://www.mvps.org/access/api/api0068.htm

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

Could you let me know the links or any code, how to do this programmetically. Thank you
This was also suggested in stackoverflow.com/questions/435206/…
Sorry Remou - I should have linked to your answer instead of stealing the link :-)
I Have tried using API, But it is not working...also not showing any error. Please let me know any other way of approach.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.