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 ?
LVL 1
Alaska CowboyAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
There's also this as an option for some:

    www.eqldata.com

  Out of all the options, Terminal Services is the best approach overall for a JET based Access app.  It's basically a plug and play situation, with no app changes.

JimD.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
In order to do this, you must have a VPN connection to the folder hosting that database, and Access databases do NOT work well across WAN's unless you enjoy a VERY high speed, robust and reliable WAN (and the overwhelming majority of scenarios would not fit that bill).

Terminal Services will work, but you'll have some outlay involved. YOu'll have to purchase and setup a Microsoft Server environment, which can rack up some serious money. You'll then need to implement Terminal Services, which costs you for the CAL's needed.

There's also VNC and the various flavors of that. It can work pretty well, depending on your needs (but it's also a single-user type setup, for the most part).

Of course there's LogMeIn and GoToMyPC, but again, they're limited and often not suitable for what you're after.

http://www.thinsoftinc.com/support_winconxp.aspx is a viable replacment for Terminal Services. I've not used it, but it has been recommended by other Experts whose judgement is well trusted.
0
 
msluneckaConnect With a Mentor Commented:
Do you need several people to be able to access it at once?  If not just get yourself a free account at Dropbox.com and keep your file stored there.  Just make sure you're either using the desktop software to keep the folder synchronized or you're manually re-uploading the file when you're done editing.

That's a cheap-as-free solution, but my honest recommendation is to get away from access as storage mechanism.

Get yourself an MSSQL database and import your access tables into that, and use access as a front-end to point to those tables.  It will require re-writing some of the forms, table links, etc...but long term it's a much better solution.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
bjohnson_MNConnect With a Mentor Commented:
I would agree with the top items, although there are some tools available now to publish Access to Sharepoint (I believe).

Further, the VPN solution works well, if your office has quality upload speeds.  You can purchase an inexpensive Firewall with VPN capabilities by Netgear, and Sonic Wall.

LIke I said, it works over VPN, but make sure your upload is sufficient.
0
 
Alaska CowboyAuthor Commented:
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 ?

0
 
Alaska CowboyAuthor Commented:
bjohnson_MN, thanks as well.
0
 
Alaska CowboyAuthor Commented:
JDettman, thanks as well.
0
 
Alaska CowboyAuthor Commented:
LSM, Thinsoft looks like a good solution.

JDettman - also a good, quick solution, thanks.
0
 
Alaska CowboyAuthor Commented:
good options, thanks.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.

0
 
Alaska CowboyAuthor Commented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
Alaska CowboyAuthor Commented:
LSM, ok, will let you know if I try it, need to talk to my client first.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.
0
 
Alaska CowboyAuthor Commented:
JimD, ok disclaimer noted so will proceed carefully.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.