Moving Database 2

[Fizbann]

I have a main database called forms.mdb and one called data.mdb. forms.mdb is the main database and has four linked tables from data.mdb.
The link manager gives me the full path to these four tables: c:access\forms\data.mdb

When moving the databases to another computer and/or folder the database doesn't work, it remembered the full path.

Is there a sollution to remove the full path and chache it into a reletive path: .\data.mdb ?

 

[ulteriormotif]

I haven't found it yet if there is.

It would be very handy though. It's the one thing that stops me front/back ending a lot of my databases, as they are distributed to users who would find updating the links a huge challenge.

 

[danvlas]

Try my

ftp://ftp.artrom.ro/DBLinks97.zip

It's for Access 97, but I guess you can import the objects and set a reference to DAO in Acc 2000 or XP and it will work just fine.
I'll post the ADO version when I find the time to do it...

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MichaelRed]

ALWAYS use "URL" notation for table links. They will contiinue to work regardless of hte location of the FE. Moving the BE is somewhat more complex, as SOMEBODY needs to know whither it went.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places