🚀 go-pugleaf

Any consultant or network support company that suggests to even waste your
time attempting to run ms-access as a file share across a wan on a VPN
should be fired.

Simply put, you will damage and corrupt that file on a regular bases. I am
not sure who is the consultant who set up the VPN, but don't these people
ask a few basic questions as to the type of software and applications you
are running? This is just sheer incompetence, and gives the IT industry a
bad name. You cannot even come close to attempting this.

Of course you are not going to get enough speed. (did not anyone check the
difference in speed between a office LAN and a vpn?).

Assuming someone did come along and get you enough speed, as mentioned, a
wan is subject to temporality dis connects, and that will damage the
ms-access database on a regular bases. (you will have to resort to the
previous days backup on a regular bases).

You have several solutions. You could modify the application to work with
sql-server. However, to make sure that the application uses a absolute
minimum of bandwidth, you really need some careful designs.

The best solution is to use some thin client technology. Windows Terminal
Server is the best solution here. With any connection faster than a 56k
modem, your users will not even tell the difference between running it
locally, or remotely on the side of the country. TS absolute rocks, and runs
circles around products like VNC (which is free), or products like
pc-anywhere. If you are running windows 2000 server, then you can test how
well the application will run. You get two free TS licensee on windows 2000
server. (just setup TS to be run in adim mode..it is only a few mouse
clicks, but does require a server re-boot).

In fact, TS is even workable from a modem connection also. You did not say
how many remote users you need, but TS is a great way to go, since you do
NOT have to re-write one line of code. You can also run your application
through the browser if you also start running IIS on the server, but don't
think that is needed.


--
Albert D. Kallal
Edmonton, Alberta Canada
kallal@msn.com
www.attcanada.net/~kallal.msn