View Full Version : Linked Tables on Portable Drive


Brent162
02-13-2008, 05:20 PM
I'm trying to create a database that totally resides on a portable drive.
My problem is linked tables become broke as the drive letter changes.
I am fairly new to Access, So will Apologize in advance.
Drive:
Main.mdb
\Folder
\Linked.mdb
Should it look Like this when I link:\\Folder\Linked.mdb
again I Apologize, If this is really simple.

Guus2005
02-14-2008, 03:29 AM
I am assuming you have thorough knowledge of VBA. (If not, search this forum.)
When you start up your database, refresh all the links of the current database.
When you can't refresh a linked table, open a dialog box and get the path to the attached table/database.

In your case using an UNC path ("\\Server\Directory\Database.mdb") should fix your problems.

Enjoy!