Access database access through shared network drive

[rajfido]

Hi,
We have a ms access application with a front end .mdb file with the forms
and a backend .mdb with the tables. The backend is stored on a shared
network drive and all users have their personal copies of the front end on
their workstation's hard disk.

We have a team in India who also need to acess this .mdb backend
application. They can get to the backend .mdb file using their windows
explorer by mapping the ip address of the machine where the backend .mbd is
stored. When they try to map the backend .mdb to the front end access file,
it gives an error message saying "The file is located outside your intranet
or an untrusted site. Microsoft Access will not open the file due to
potential security problems. To open the file, copy it to your machine or an
accessible network location."

Is there a solution to this ? Is there any specific protocol or port number
through which MS Access tries to make the connection for which network access
has to be granted by the firewall engineers so that they can access it as if
it were on their own network ?

 

[Arvin Meyer]

I suggest that the Indian team gain access to the database via asp pages.
Even if you were able to successfully connect, it would be so slow that any
cost saving gained by using off-shore programmers would be nullified. If
only one person at a time need gain access to the database backend, you
could set up a front end on the server as well and connect via terminal
services.

Just my 2 ¢
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access