Link to home
Start Free TrialLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

asked on

How to access MS-Access datatbase remotely

I want to access an MS-Access database remotely. I'm pretty familiar with the considerations but just thought I'd ask.

I'm assuming the only way is to remote desktop into a PC running the d.b. But Windows XP / Vista / 7 doesn't allow for multiple users, correct ? So is there any Windows option for multiple users ?

Citrix would be a high-end option, as I've seen that work.

A colleague uses HyperOffice and I checked that out and it practically looks like a Windows server, but being on the Web,  MS-Access doesn't work in its natural state.

Any other creative solutions ?
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alaska Cowboy

ASKER

LSM, thanks for the tips.

mslunecka, yes, they'll need multiple users. In regards to getting MS-Sql d.b., that doesn't really solve the "remote access" issue, does it ?

bjohnson_MN, thanks as well.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
JDettman, thanks as well.
LSM, Thinsoft looks like a good solution.

JDettman - also a good, quick solution, thanks.
good options, thanks.
Just to be clear: VPN has never been advocated as a reliable method to remotely work with Access. While some may get away with it, nearly every developer I know of (as well as the Access team) does not advocate this method of using an Access database. Unless you enjoy a VERY wide, fast and STABLE pipe between the endpoints, you'll end up with (a) unhappy users, (b) constant data corruption of (c) a lot of both.

LSM, ok, thanks for the clarification. This is a small business so VPN is out of their (and my) league.

I like the Thinsoft option as well eql-data.
If you do use EQLData, please report back here and let us know what you think of it. We've seen it around a bit, but so far I've not heard back from anyone whose actually used the service. Seems like a good idea, but it'd be nice to have some firsthand experience.
LSM, ok, will let you know if I try it, need to talk to my client first.
<<If you do use EQLData, please report back here and let us know what you think of it. We've seen it around a bit, but so far I've not heard back from anyone whose actually used the service. Seems like a good idea, but it'd be nice to have some firsthand experience. >>

  Ditto here.  I should also add that I have no connection with them what so ever and have no experience with them.  Make sure that it works and works well for you.

JimD.
JimD, ok disclaimer noted so will proceed carefully.