Alaska Cowboy
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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
bjohnson_MN, thanks as well.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
JDettman, thanks as well.
ASKER
LSM, Thinsoft looks like a good solution.
JDettman - also a good, quick solution, thanks.
JDettman - also a good, quick solution, thanks.
ASKER
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.
ASKER
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.
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.
ASKER
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.
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.
ASKER
JimD, ok disclaimer noted so will proceed carefully.
ASKER
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 ?