How to avoid Linked Table manager message while opening the Access DB.

Question

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???

Answer 1

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