new location of access mdb

[dbyy]

HI everyone,

I wonder, how can I change the location of a linked database?
I have two databases, one is the main db (tables) and the other one
contains several reports.
when I moved the main database to a new location, it seems to me the linked
database has the old location 'burned in'.
How can I chcnge that?

MS Access 2000

Any help appreciated

TIA
Fred

 

[Curt]

One way to do this is to map a drive to your database, and link your tables
to the mapped path. If you move the database, you also need to remap your
drive. That way, your database always has the same path, relative to the
mapped drive. This is an especially good solution when you have multiple
users running copies of the application. To avoid re-mapping all users'
mapped drives, always store the database in a network share. This way, you
can remove the share when you move the file, and recreate the share at the
new location. This assumes you are not moving the database to a different
server.

Example:
Database resides on C:\Databases\. Share this folder as "Datashare". Map a
drive letter, use X: for example, to \\ServerName\Datashare.
Your C:\ drive is full so you move the database to D:\SharedDocs. Remove
the share "Datashare" from C:\Databases and create a new share of the same
name on D:\SharedDocs. Your X: drive is already mapped to
\\ServerName\Datashare so you don't need to do anything else.

Another approach is to write code to actually relink the tables when
necessary. This option requires you to supply the new path when the relink
code executes. If multiple users use copies of this application, each one
will need to relink the tables.

Good luck!
Curt