Unless you can guarantee that the same drive letter will be mapped to
whichever server/share is appropriate for each location, you'll have to
refresh the links at each location.
It should be possible, however, to add code to the application so that it
can check whether the tables are linked appropriately, and relink if not.
http://www.mvps.org/access/tables/tbl0009.htm shows some code that may help.
While that code prompts the user, and lets them pick the correct location,
you could rewrite it to automatically pick the correct location by replacing
the section of code
strMsg = "Do you wish to specify a different path for the Access
Tables?"
If MsgBox(strMsg, vbQuestion + vbYesNo, "Alternate data source...") =
vbYes Then
strNewPath = fGetMDBName("Please select a new datasource")
Else
strNewPath = vbNullString
End If
with code that sets strNewPath appropriately.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Melissa" <mb****@earthlink.net> wrote in message
news:CH*****************@newsread3.news.atl.earthl ink.net...
A company wants to install a database on the network at 15 different
locations. The networks are all separate, are mapped differently and the
server name and share are named differently for each location. Is there
any way to create a linked tables path that will work at all the locations or
does the database need to be installed one at a time at each location and
the tables links refreshed for each location?
Thanks!
Melissa