Global Table Links In Access 2000

[Joseph Barneski via AccessMonster.com]

I have a front end application that I link to a back end database. Both are created using Access 2000. If you link the tables between the two, you get a fully qualified path (UNS or local). The application and data have to be easily exportable. I just want to point all links in the Front End to the data located in the same directory as the backend.

Example:
USING the Linked Table Manager -
Link = "C:\database\mydata.mdb"
or
Link = "//myserver/database/mydata.mdb"

What I WANT is -
Link = ".\mydata.mdb"
or
Link = "mydata.mdb"

This saves my users from having to link the tables when they stand up the program and makes MY job when I update the front end so much easier.

I HAVE researched this ALOT before actually posting... I have tried autolinking scripts and the "oconn" to no avail.

Is this just something I have to live with? PLEASE say no!

Thanx!!!
Joe Barneski

 

[Larry Linson]

The Access 2000 Solutions MDB (which is temporarily housed at
http://www.mvps.org/access/download/bapp2000.exe) has a topic on Relinking
Tables at Startup. That should give you a start on what you want to do.

Larry Linson
Microsoft Access MVP

I have a front end application that I link to a back end database. Both

are created using Access 2000. If you link the tables between the two, you
get a fully qualified path (UNS or local). The application and data have to
be easily exportable. I just want to point all links in the Front End to
the data located in the same directory as the backend.

Example:
USING the Linked Table Manager -
Link = "C:\database\mydata.mdb"
or
Link = "//myserver/database/mydata.mdb"

What I WANT is -
Link = ".\mydata.mdb"
or
Link = "mydata.mdb"

This saves my users from having to link the tables when they stand up the

program and makes MY job when I update the front end so much easier.

I HAVE researched this ALOT before actually posting... I have tried

autolinking scripts and the "oconn" to no avail.