Opening an mdb via vpn connection

R

Rick Starnes

I have a Windows 2000 file server (without Access 2002 installed) with a
Access 2002 mdb uploaded. My user is remote with Access 2002. When they
connect through the VPN tunnel and attempt to open the mdb, they only get the
front end yet they need the back end also. What is the resolution to this
problem?

Thank you.
 
P

Paul Overway

The front end should be on their PC already. Nevertheless, you're looking
for trouble by opening any MDB over a VPN. Performance will be terrible and
you run the risk of corrupting the file. You should look at alternatives,
i.e., terminal server, PC AnyWhere, etc..
 
V

Van T. Dinh

In my experience, it will be unacceptably slow using VPN to open an Access
database even when it works which is not reliable at best.

You will need to look at alternatives like Terminal Services or Citrix or
similar.
 
R

Rick Starnes

Is this true even with Broadband? And will it work any way after loading
Access on the server?
 
R

Rick Brandt

Rick said:
Is this true even with Broadband? And will it work any way after
loading Access on the server?
Click to expand...

Yep. You have to keep in mind that even the best broadband is anywhere from
100 to 1000 times slower than a LAN. Broadband providers might be pretty
impressed with their services, but compared to ethernet it's still VERY
primitive.
 
R

Rick Starnes

What are your thoughts about using pcAnywhere?

Rick Brandt said:
Yep. You have to keep in mind that even the best broadband is anywhere from
100 to 1000 times slower than a LAN. Broadband providers might be pretty
impressed with their services, but compared to ethernet it's still VERY
primitive.
Click to expand...
 
R

Rick Brandt

Rick said:
What are your thoughts about using pcAnywhere?

"Rick Brandt" wrote:
Click to expand...

I've used it and it does the job, but the problem with it (and many other remote
software solutions) is that its a "One PC per Remote User" solution. With
Terminal Server you can have one server host a large number of remote users.
PCAnywhere is one user consuming one entire PC that just happens to be at a
remote location.
 
Top