Relink tables on Startup and catch ms access error

[Curious]

Hi,

Using the code found here: http://www.mvps.org/access/tables/tbl0009.htm

I have put the function to relink my tables into the OnOpen event of my Startup form.

The function relinks fine, however, if the back end tables are missing, ms Access reports it's usual error: "Could not find the file .... mybackend.mdb"

Then it exists and doesn't give my relinking code a chance to run.

Is there a way to make my code run after or in place or that error message?

 

[boblarson]

The function relinks fine, however, if the back end tables are missing, ms Access reports it's usual error: "Could not find the file .... mybackend.mdb"

Then it exists and doesn't give my relinking code a chance to run.

Is there a way to make my code run after or in place or that error message?

You need to call the code from an AutoExec macro which will run before any forms are loaded. If you don't you will get your error.

 

[Oldsoftboss]

This is how I do it.

http://www.access-programmers.co.uk/...ad.php?t=64270

Works well.

 

[boblarson]

This is how I do it.

http://www.access-programmers.co.uk/...ad.php?t=64270

Works well.

I tried clicking on your link but the link was dead.

 

[Oldsoftboss]

Thats what you get with cut and paste !!

http://www.access-programmers.co.uk/forums/showthread.php?t=64270