Open access Front End through VPN

[kilt]

Hi everyone,
I set up a VPN to Remote Access into our Access XP database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article to support the error message says you have to retrieve display records by using ASP.Net, ADO.net etc, which will require programing skills.( KB 810582 ) Has anyone had this same problem & did they find a less work intensive solution?

TIA
Kilt

 

[BNPMike]

That sounds odd doesn't it? You wouldn't think any part of Access could tell you were on a VPN. I would have thought that would have been transparent. You have Access on each of the client workstations?

 

[cmmrfrds]

You should be able to run the application if the server is running Terminal Services or it is on a Citrix Server or comparable server. Running an Access app from a Cirtix Server is a common approach. Terminal Services comes free on Windows 2000 Server, but Citrix is pricey.

 

[kilt]

Thanks for the replies guys. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas?

Thanks,

Kilt

 

[cmmrfrds]

Can you quantify - too slow! Is it just certain screens or everything.

What is the bandwidth on the network?