Solved

How to access MS-Access datatbase remotely

Posted on 2011-02-18
15
459 Views
Last Modified: 2012-06-27
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 ?
0
Comment
Question by:Alaska Cowboy
  • 8
  • 3
  • 2
  • +2
15 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 100 total points
ID: 34928889
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
 
LVL 6

Assisted Solution

by:mslunecka
mslunecka earned 25 total points
ID: 34928901
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
 
LVL 1

Assisted Solution

by:bjohnson_MN
bjohnson_MN earned 25 total points
ID: 34928989
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34928994
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34929220
bjohnson_MN, thanks as well.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 34929350
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34929371
JDettman, thanks as well.
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34930253
LSM, Thinsoft looks like a good solution.

JDettman - also a good, quick solution, thanks.
0
 
LVL 1

Author Closing Comment

by:Alaska Cowboy
ID: 34930261
good options, thanks.
0
 
LVL 84
ID: 34930621
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34930665
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
 
LVL 84
ID: 34932702
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34932708
LSM, ok, will let you know if I try it, need to talk to my client first.
0
 
LVL 57
ID: 34932909
<<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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 34933349
JimD, ok disclaimer noted so will proceed carefully.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question