Install database at multiple locations

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

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
 
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.
 
There is a way...

You can create a macro to link your database to a table in another database,
the trick is to use the physical name instead of the logicalname. For example:

New Macro:

Action: TransferDatabase
Transfer Type : Link
Database Type : Microsoft Access
Database Name : \\YourServer\YourFolder\database.mdb
Objecct Type : Table
Source : TableName
Destination : TableName

If you open the Windows Explorer, you will see the drives like:
wrkgrp on 'srv01' (X:)

in this case, in database name change \\YourServer\YourFolder to
\\srv01\wrkgrp and them the full path you already know. ;)

if it was X:\database\finance\finance2004.mdb
it will be \\srv01\wrkgrp\database\finance\finance2004.mdb

Now, your link is not linked to the letter of the drive, but the name of the
server...

Have fun !!!!

Mauricio Silva
 
Back
Top