Access via VPN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yanto - 30 Apr 2007 11:10 GMT

Hi Alll,
I have an Access database on branch office (other country) I need to
connect from oother place via VPN.
What is the best method to connect Access database via VPN? if
possible to connect direct via VPN. Have tested using WinXP-VPN
setting for both computer but very slow. Or must use Replication
method? Is it possible to use access in client-server style?
TIA
Yanto

Reply to this Message

Ken Snell (MVP) - 30 Apr 2007 13:41 GMT

Use Remote Desktop (if your version of Windows supports it) or a client such
as Citrix. VPN is extremely slow and not recommended.

Albert Kallal (MVP) has a lot of info about this:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Signature

Ken Snell
<MS ACCESS MVP>

> Hi Alll,
> I have an Access database on branch office (other country) I need to
[quoted text clipped - 5 lines]
> TIA
> Yanto

Reply to this Message

Aaron Kempf - 02 May 2007 21:20 GMT

CORRECTION!

VPN is not slow-- ADP works _GREAT_ over a VPN

MDB is slow and is not reccomended

> Use Remote Desktop (if your version of Windows supports it) or a client such
> as Citrix. VPN is extremely slow and not recommended.
[quoted text clipped - 11 lines]
> > TIA
> > Yanto

Reply to this Message

Jan Kowalski - 30 Apr 2007 15:06 GMT

> Hi Alll,
> I have an Access database on branch office (other country) I need to
[quoted text clipped - 5 lines]
> TIA
> Yanto

Reply to this Message

Scott McDaniel - 01 May 2007 00:44 GMT

>Hi Alll,
>I have an Access database on branch office (other country) I need to
[quoted text clipped - 3 lines]
>setting for both computer but very slow. Or must use Replication
>method? Is it possible to use access in client-server style?

You can connect to the database via VPN, but it'll be SLOW and the chance for corruption is pretty high. You'd be better
off replicating the database, or moving to a server type database like MS SQL or MySQL. Access (actually the Jet
database engine) cannot be used "client-server" style that would be of any advantage to your problem.

Another option is Terminal Server or Citrix over your VPN. This works very well in most cases, although it does require
a bit of setup and maintenance.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message

yanto - 01 May 2007 08:36 GMT

Thanks for any response
Your information is valuable to me.
Best Regards
Yanto

Reply to this Message

Aaron Kempf - 02 May 2007 21:19 GMT

Access via VPN is only supported if you're using Access Data Projects

these MDB chipmunks tell you to buy another server-- it's comical-- the only
server you need is a DATABASE SERVER

> Hi Alll,
> I have an Access database on branch office (other country) I need to
[quoted text clipped - 5 lines]
> TIA
> Yanto

Reply to this Message