Link to home
Start Free TrialLog in
Avatar of gerlis
gerlis

asked on

Access database located in "cloud" storage

Our client uses a custom database written in Access. We are now moving their small system, all their documents,  into the "Cloud", the three users will now work from home i.e. this is a secure online storage, all their files used to be on a small NAS in their office, but the database is/was used on one PC.

They are having some difficulties running the database where the .mdb file is stored in the cloud. The Access program is on the local PCs.

My knowledge of Access, what little there is, goes back some 20 years! However, the  .mdb file is not in the same location as the Access program itself.

I seem to recall that there is a configuration element which can tell Access where to go looking for the .mdb file?

All ideas welcomed
SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gerlis
gerlis

ASKER

Thanks to all who've replied. Especially for clarifying that Access will not work in this way.

My colleague who knows a bit more about Access than I do, had also suggested splitting the DB as suggested by PatHartman.

Found this article: http://www.granite.ab.ca/access/splitapp/overview.htm

We're looking into it.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gerlis

ASKER

Thanks, Jim. Very timely as client has asked if Dropbox could be used!
Avatar of gerlis

ASKER

You have all been extremely helpful in explaining tht situation with Access in this instance
you're welcome ~ happy to help
You could keep the DB on a local computer / NAS and setup a VPN from the local computer to the homes.  Once the VPN is setup it would behave as if its all on a local network.
The VPN solution will normally be slow enough to be annoying.
Avatar of gerlis

ASKER

Thanks for your continued help and interesting comments.

Seems it all comes down the the speed of the network.
<<You could keep the DB on a local computer / NAS and setup a VPN from the local computer to the homes.  Once the VPN is setup it would behave as if its all on a local network.>>

While a VPN would make it appear "local", a VPN would not cut-it....you still running over a WAN link with slow speed and high latency.   With Acccess using JET or ACE for a database engine, for remote users, an RDP situation is pretty much it.

Jim.