It will not relink Access database tables unless they have already been linked.There are a few things the code will not do: Unlike some methods, will not lose your linked table or TableDef if there is an error.Does not require you enter or store database or table names.Relink tables in multiple back-end Access databases.Relink tables when the databases are moved to a different folder or a different computer.Relink all linked Access database tables if the back-end and front-end are in the same folder.The code loops through the TableDefs Collection and uses the TableDef RefreshLink Method to Refresh the links. The code then uses this information along with the existing path of the front-end database to get the string needed to set the TableDef Connect Property. This includes the names of your linked tables and the names of your back-end databases. The code gets important information from the TableDefs collection in your front-end. Additionally, you do not have to enter the names of your back end database(s) or your linked tables. You do not have to be physically present, nor do you need to remotely access another computer. It can save you a lot of headaches, trouble, travel, and time. This is especially true if you are distributing your database to others.
And best of all, you don’t have to know much about writing code to make this work.Īutomating the relinking of tables just makes good sense.
The procedure will also relink the tables in multiple back-ends. For more information, contact this article we will show you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. He also founded Microsoft Access and SQL Azure Information Cente r for developers. ( Guest blogger Patrick Wood, an Access MVP, is the founder of Gaining Access Technologies, a software company specializing in working with SQL Azure and Access.
0 kommentar(er)
