Testing Table Link and setting to Default if missing

[isorders]

I have a front end database that can connect to different companies, on open I want to check to make sure that the linked tables are valid in case a specific company file has not been renamed or deleted.
If the company file is missing, I want it to link to a default database.
The tables in all of the company databases will have the same structure.

Thanks

 

[danvlas]

Try opening the tables as recordsets, and if error occurs, either change the Connect property to the default or delete the table and re-link it from the default company.

Good luck


Daniel Vlas
Systems Consultant
danvlas@NOJUNKyahoo.com
(remove NOJUNK to use, but only if absolutely necessary. I also need time for my own)