Various methods are available to link tables manually and automatically. In the following sections, you see how to link a back end, based on it being in the current folder or in another folder.
Note
To see how to check for and re-create a connection between an ADP and SQL Server, check out Chapter 25, “Developing SQL Server Projects Using ADPs.”
In section 4, the ap_AppInit() function checks to see whether the back-end database is in the same folder as the front end and, if so, links the tables automatically.
'-- Section 4: If the Data MDB is found in the App Directory, '-- link the files. If Dir(pstrAppPath & "\" & pstrBackEndName) ...
No credit card required