Re: Access via VPN

On 30 Apr 2007 03:10:44 -0700, yanto <yanto2000@xxxxxxxxx> wrote:

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?

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@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • Re: Windows 2003 VPN Speed limit??
    ... VPN and database operations are not a good ... so that both database client and server are on the fast ... Ethernet connection. ...
    (microsoft.public.windows.server.networking)
  • Re: Multiple Simultaneous Sessions on Remote Desktop PC
    ... a plain VPN.. ... Although XP Pro supports only one incoming connection, ... Remote Networking Technology Support Site - ... >Because the solution is not based on a server database ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Working from afar
    ... either vpn or terminal server. ... In our scenario we VPN ... We found using filemaker straight over a VPN was unusably slow with our ... database (which admittedly is complex and has lots of relationships, files, ...
    (comp.databases.filemaker)
  • Re: Vpn from Internal to External Application Issue
    ... The database is only accessible thru a vpn - it is customer controlled so I ... the vpn connection however unable to then use the 32bit app to connect to ... his sql database unless I disabled the local fwc. ...
    (microsoft.public.isa)
  • Re: VPN
    ... the database due to slow transfer times. ... restricted VPN in the manner you describe, but the great majority of (even ... >> Allowed users can establish a secure HTTPS connection to the server, ... > can then limit the exposure through firewall rules. ...
    (microsoft.public.windows.server.sbs)