Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

Accessing My Small Database from Anywhere

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
Patrick O'Dea
Asked:
Patrick O'Dea
  • 4
  • 3
  • 2
  • +3
4 Solutions
 
Kash2nd Line EngineerCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
peter57rCommented:
So each user has an Ipad.
How do they get in to the Access application when they are in the office?
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
shalomcCTOCommented:
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
 
Patrick O'DeaAuthor Commented:
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
 
shalomcCTOCommented:
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
 
Patrick O'DeaAuthor Commented:
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
 
shalomcCTOCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Also check out www.eqldata.com

Any device that has a browser can use the DB.

Jim.
0
 
Patrick O'DeaAuthor Commented:
Thanks,

I give the "logmein" route a try.
0
 
Patrick O'DeaAuthor Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<(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

Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

  • 4
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now