Where to start w/Remote Access?

[beachcomber]

Hi,

I'm relatively new to remote access issues. I'm
more familiar with programming. So, I could
really use someone to help point me in the right
direction here. We have an Access program
that will be used by several remote users. We
would like the remote users to all share the
same database for the program (we would like the
database to be on a main server accessible by the
remote users).

Can anyone point me in the right direction for
how to solve this problem? Would putting the Access
database on a server and setting up a VPN
to the server be the way to handle this?
Can the remote users simply set up an ODBC connection
to the remote server with the database?
Any advice, suggestions?

Thanks for any help.

Beachcomber

 

[Sifer]

Hi Beachcomber!

A VPN connection will work but in our testing, the performance of Access databases over a 56k modem was thoroughly unacceptable. Perhaps if your remote users had cable or DSL the situation would be different. We had to make it very clear to our users that using Access databases is unsupported even though it may work due to timeouts and slow performance.

One way you can get around these performance problems is to have your remote users connect to a Citrix Server or use Terminal Services that can run the database for them.

Cheers

Sifer

 

[beachcomber]

Hi Sifer,

Thanks for the response. This is good to know since some of our remote users do not have cable or dsl.

Beachcomber