Install database at multiple locations - 09-30-2004 , 10:33 AM
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?
Re: Install database at multiple locations - 09-30-2004 , 10:59 AM
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
If MsgBox(strMsg, vbQuestion + vbYesNo, "Alternate data source...") =
strNewPath = fGetMDBName("Please select a new datasource")
strNewPath = vbNullString
with code that sets strNewPath appropriately.
Doug Steele, Microsoft Access MVP
(No private e-mails, please)
"Melissa" <mbaker (AT) earthlink (DOT) net> wrote
Re: Install database at multiple locations - 09-30-2004 , 09:54 PM
Do you know the server names and shares of the 15 locations? If so,
then you could create a table in the frontend that contained all the
server & share names. If the database links to the backend were found
to be invalid, then you could scan the table to find the possible
locations. Only after exhausting the list of "known" locations would
you have to ask the user to locate the backend.
Once a valid location is found, you can store it in the computer's
registry to avoid having to repeat the process if you were to update
On Thu, 30 Sep 2004 15:33:54 GMT, "Melissa" <mbaker (AT) earthlink (DOT) net>
jackmacMACdonald (AT) telusTELUS (DOT) net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security