Solved

Accessing My Small Database from Anywhere

Posted on 2013-02-04
12
318 Views
Last Modified: 2013-02-04
Hi,

I have a client who with an access database (I developed).
There are 3 users on the system and the level of data processed is very low.

Indeed, it is a non-critical system.  I.e. It would not be a disaster if it was not accessible for a short period.

My users travel around and need full use of the database via wireless connections.  So for instance, my client might visit one of their customers and then fill in details of the visit on their iPad - directly into the Access database.

So the requirement is simple.
Anytime, anywhere access to existing simple Microsoft Access Database.

There seems to be a variety of solutions out there.
What way should I go?


Thanks , as ever , to all experts.
0
Comment
Question by:Patrick O'Dea
  • 4
  • 3
  • 2
  • +3
12 Comments
 
LVL 19

Assisted Solution

by:Kash
Kash earned 75 total points
ID: 38850304
does your client have a fixed IP and a domain ? if there is then it is fairly easy to do so.

All you need to to open ports on the router and forward it to the right place / IP where the database resides. It should then be accessible. That is one way of doing it.

the second option would be to have a use of VPN. Let the router do the VPN for you.

then all your client needs is the FIXED IP and username/password details. Once on site, he/she can dial VPN and he will be as he was in office and can then connect to the DB. hope this helps.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 75 total points
ID: 38850544
The only reliable way to do this is to use remote desktop technology. You can't reliably run an Access database across a WAN.

There are many remote technologies, from the builtin Remote Desktop to paid commercial products like ScreenConnect or TeamViewer. I'm not sure of the best remote product for the IPad.
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 75 total points
ID: 38850551
So each user has an Ipad.
How do they get in to the Access application when they are in the office?
0
 
LVL 33

Expert Comment

by:shalomc
ID: 38850615
TeamViewer works fine on an iPAd, so does Logmein.
I prefer Logmein because it gives me a better centralized control, but it is up to you to decide.

The laternative to using a remote desktop would be to write a custom application for the iPad, possibly using HTML5 so it works on all mobile platforms.

You will end up with a 3 tier application: the access database, a web server with custom code, and the ipad app.
0
 

Author Comment

by:Patrick O'Dea
ID: 38850736
Thanks for feeback so far.

A couple of comments.

1. My technical skills relate to Microsoft Access.  So the solution must be not get to complicated on the "infrastructure" side.

2. Given 1 above, I would guess that the only way to use the database on an iPad is by logging onto the internet.   I.e. An "app" would be out of the question at this point.

3. Does the fact that i want to use an iPad make life much more complicated than using a wireless laptop?


Sorry that my questions are not more focussed.  When I google the issue of putting my access database in the cloud or similar, I seem to be presented with loads of possibilities.  But perhaps they are somewhat misleading?
0
 
LVL 33

Expert Comment

by:shalomc
ID: 38850788
How do the client's users access the database at the moment?
Do you have a single PC / terminal server with remote desktop?
Do you have 3 installations for 3 users?
An iPad for this matter is just like a laptop.
0
Don't lose your head updating email signatures!

Do your end users still have the wrong email signature? Do email signature updates bore you or fill you with a sense of dread? You can make this a whole lot easier on yourself by trusting an Exclaimer email signature management solution. Over 50 million users do...so should you!

 

Author Comment

by:Patrick O'Dea
ID: 38850816
shalomc,

Client has a small network in their office.
The database is held centrally on this server.
3 desktops PC's (but iPads are used when they leave the office which is frequently).

One PC has full microsoft access.
The other 2 have a runtime version  of access.

Thanks for your assistance.
0
 
LVL 33

Accepted Solution

by:
shalomc earned 275 total points
ID: 38850847
Create a Logmein account. Free for 5 or less users, although the paid subscription has it's benefits, like real customer support and improved features.
Install logmein clients on all 3 PCs.
Install logmein apps on the iPads.
Connect ipads to PCs.
0
 
LVL 57
ID: 38850859
Also check out www.eqldata.com

Any device that has a browser can use the DB.

Jim.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 38850862
Thanks,

I give the "logmein" route a try.
0
 

Author Comment

by:Patrick O'Dea
ID: 38850869
Thanks Jim,
I will look at the www.eqldata.com

(Incidentally, you're famous!   ...... I listened to your podcast on "cloud" for Access a few days ago.   Very interesting, but some of it a bit beyond my level..)
0
 
LVL 57
ID: 38850941
<<(Incidentally, you're famous!   ...... I listened to your podcast on "cloud" for Access a few days ago.   Very interesting, but some of it a bit beyond my level..) >>

 Not really.  I'm just one of many voices in the Access world.

 Actually, if you look at it the other way, EE needs to fill air-time with something<g>.

Jim.
0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now