Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Link table with a relative path
Thanks Golom. After some minor modifications to deal with passwords on both dbs and unknown file locations until runtime, the code provided did the trick. Here is the final code. Private Sub UpdateMSysObjectsPath() Dim db As DAO.Database Dim tbl As DAO.TableDef On Error Resume Next...- pnovreske
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Link table with a relative path
Thanks for your response. My .mdb file is exclusively a back end for my app and is never opened via Access. Therefore any code to manipulate the db needs to reside in the VB app. If this were an "Access" app, I would have a number of options, including the one you referenced. Any...- pnovreske
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Link table with a relative path
I am dealing with a legacy VB6 app that has an Access backend. The db contains a linked table. The primary db file are each in their own directory. For example C:\My Location\ABC\db_abc.mdb C:\My Location\XYZ\db_xyz.mdb db_abc.mdb links to a table in db_xyz.mdb. Is there a way to have...- pnovreske
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
