Connect to our Access DB from Internet

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

Hi,
This is what I want to do:
1. I have one Access database on a server behind our firewall
2. I want user to be able to connect to this database from their home or
other places where they have an Internet connection.
So what is the best solution for the above problem??? Can someone please
give me some guidelines..
// Kenneth
 
Hi,
This is what I want to do:
1. I have one Access database on a server behind our firewall
2. I want user to be able to connect to this database from their home or
other places where they have an Internet connection.
So what is the best solution for the above problem??? Can someone please
give me some guidelines..
// Kenneth
Click to expand...

Hi Kenneth,

One way to do this is to set up a VPN (Virtual Private Network)
connection on your server. When your home user connects, they can
access all network shares including the Access database.

This can be pretty slow, but it works. Using it over a modem connection
will be tough unless the amount of data is tiny.

I'm not an expert on setting up VPNs - any decent network administrator
can do it. There are both software (Windows 200x) and hardware
(router/firewall) ways to do it.
 
You can't really use a file share over the net. You best solution is to use
Terminal Services.

If you are running win2000 server, then you can have up to two users connect
and run applications like ms-access for free, and you can connect *across*
the internet. If you need more then two users, then you have to start paying
for additional licenses. I do think using Terminal Services is the best
approach.

For some ideas on using ms-access across the internet, networks, and other
possible solutions to your problem, you can read the following article of
mine, and it sums up your options quite well:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html
 
Back
Top