Dynamically Linking Tables Vs. Static Linked Tables

[Ernie]

I'm using MSACCESS 2002 and have developed a database
with the traditional Frontend-forms- being linked to the
Backend Data. My problem is the data directory is mapped
differently for each user using the front end. Is there
a way to prompt the user on first time use of the front
end database where the back end is? OR Can I use ODBC
(which I have tried but get error msg saying can't do
with access)?

Any help is appreciated

 

[John Nurick]

Hi Ernie,

Usually the best thing to do is to link the tables using a UNC path
(e.g. \\ServerName\Share\Folder\File.mdb ) rather than a Windows one
using a mapped drive (e.g. D:\Folder\File.mdb). In the linked table
manager, either go in through My Network places or just type the path.

If you do this before you distribute the front end to the workstations,
they should all be able to find the linked tables.

Or to relink tables from code, see
http://www.mvps.org/access/tables/tbl0009.htm