Remote Access to Database linked table relinking.

[Billp]

Hi,
I recently set up a number of databases on a new server in
another country. The server (windows 2003 small business
server) with windows 2003 loaded, had two drives c & d .
I linked all front ends to there respective backends on
the "D" drive of the server only to find drive letter
conflicts on the tin boxes linked to the server which had
a mapped drive of "J" looking at the "D" drive of the
server.Now relinking the frontends from one of the tin
boxes via there mapped "J" drive allowed the font ends to
be deployed saved as Access 2000 as all the desk tops were
running office 2000 and some were windows 98.
Ok.
Back in home country, I can see the server and the "D"
drive. Remotely opening the .MDE locked files as i don't
want to change referneces to the librarys on the .mdb
front ends. I get an error that the front end can't find
the "J" drive.
OK.
Is ther any way to create a copy of the front ends .mdb
and relink the copies to the "D" drive so that they can
utilised by remote access in a special folder?
Cheers
Bill

 

[Douglas J. Steele]

There's code in http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" to show you how to relink tables in code.

One option you have is to link using UNCs, rather than drive letters. To do
this via the File Open dialog, search through Network Places rather than via
a mapped drive when looking for the database.

On the other hand, are you saying your users are trying to connect to your
backend database across the WAN? That's generally A Bad Thing: it can lead
to corruption problems, as WAN speeds generally aren't good enough for
Access purposes.

You might want to read what Albert Kallal has to say about using Access over
the WAN at http://www.attcanada.net/~kallal.msn/Wan/Wans.html

 

[Biilp]

Thanks Doug,
for the information.
Only users in the home country will be looking not using.
Local users in the server country will be adding
information.
When the time differnce allows only minor housekeeping
will be attempted remotely untill someone can be taught
to do so in Singapore.
Warm Regards
bill

-----Original Message-----
There's code in

http://www.mvps.org/access/tables/tbl0009.htm at "The
Access