Slugmaster
Programmer
I have an Access database(DB1) that contains a couple of tables linked to another Access database(DB2). Both databases are on a network drive (ie: \\Computer1\folder\db1.mdb, \\Computer1\folder\db2.mdb).
I then used the Access replicate feature on DB1 so that my technicians can use the database on their laptops when they are on the road.
The problem is that the DB1 tables that are linked to DB2 are not accessable due to the fact that they are looking for \\Computer1\folder\db2.mdb.
I tried to make a copy of DB2 on the laptop, then modify the Connect property (in Visual Basic 6.0) from each linked table from DB1 to point at the local copy. This approach did not work, any time that I would try to access the data, the Connect property changed back to the network drive.
How can I get past this problem?
I then used the Access replicate feature on DB1 so that my technicians can use the database on their laptops when they are on the road.
The problem is that the DB1 tables that are linked to DB2 are not accessable due to the fact that they are looking for \\Computer1\folder\db2.mdb.
I tried to make a copy of DB2 on the laptop, then modify the Connect property (in Visual Basic 6.0) from each linked table from DB1 to point at the local copy. This approach did not work, any time that I would try to access the data, the Connect property changed back to the network drive.
How can I get past this problem?