open database across a firewall

M

merize

Test Network 2---->Firewall---->Test Servers---->Firewall----->main network

Client on the test network is having issues working with and access file
that resides on a server on the test network. Can open and start working
but will start having connection issues and crashes access.

anyone know of issues opening an access file this way and a solution to
that problem?

Thanks,
Merize
 
W

Wayne Morgan

What type of network connection do you have between the two firewalls? If
you're trying to open an Access Database file directly across the Internet,
don't. There are too many things that can cause data interruption and will
eventually corrupt the file. You should have a good, high speed, wired
connection to do this. If you're connection is something else, I would
recommend remote control software or setting up web pages for you to access
on the computer that has the Access file and let the web pages access the
file. Either of these options will put the job of processing the database
file onto the computer at the other end.
 
M

merize

This is all the same high speed test network, just segregated in to
pieces. Will splitting the db help or does access open both files and I
will have the same issues. how about creating a adp that uses the
standard connection to SQL server?

Thanks again,

Merize
 
W

Wayne Morgan

Top