Linking Tables

[dickw]

I have a front end/back end access application developed with the front end
and back end in the same folder. Is there a way to link tables from the
back end using a relative reference so that if both the front end and back
end databases are moved to a new folder, the links will still work?

Thanks in advance.

Dick

 

[Cheryl Fischer]

No. Access does not support this. However, should the back-end database
need to be moved, it is very easy to re-link tables using code from the
Access Web:

http://www.mvps.org/access/tables/tbl0009.htm

hth,

 

[Scott McDaniel]

You can use UNCs in your connect string, but these can get somewhat long and
have been known to cause performance issues. As Cheryl mentioned, your best
bet is to relink the tables ... you can modify the code she pointed you to
so that it will look at an INI file or Registry entry to automatically get a
valid path to your data tables. That way, if you do have to move your
tables, you can make the change in one place and all your frontends will be
notified.