Remote Access

[jason_nevin]

We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband.

I have been trying to find out the best way to achieve this over IP as we do not want the considerabe expense of leased lines. Originally we tried VPN but access seems to be very slow and appears to prohibit that route.

We were advised by our PC support company for one branch to use Terminal Services. However we do not currently have a powerful enough server to support these. We have a price for a server upgrade and it seems OK. I have since been advised by the PC support company at another branch that because of the upload speed on broadband (256Kb) Terminal Services would not be sufficient especially if we were using HTTP and VoIP over the same connection.

Looking at the various posts on this site it would seem that VPN and TS are suitable for some. Is there an easy way of calculating whether or not TS will work at our site? Has anyone gone down this route and found it not to work?

I'd be grateful for any feedback.

Thanks.

 

[KenHigg]

Seems a SQL Server or MySql type solution would address the root of your problem more directly...

 

[FoFa]

We use Citrix server to do this, works pretty good.
How ever I must point out it is sounding like you need something along the lines of a WEB front end instead of Access. You maybe just flat better off going that route. You do know you will incur IP traffic no matter how you go, just how much is the question.