In my Front end Access 2000 database, I have several linked tables from SQL Server database. How can I make sure that all tables get connected when the front end is opened? That is I am looking for some code that will check that the tables are connected and then if not it will connect them for me (w/o prompting me to do it).
ps. I found this which is perfect http://www.mvps.org/access/tables/tbl0009.htm
except that it prompts the user to re-link the tables which I do not want to do.