Linking Tables

  • Thread starter Thread starter dickw
  • Start date Start date
D

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
 
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.
 
Back
Top