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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Jim. Very timely as client has asked if Dropbox could be used!
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.
ASKER
Thanks for your continued help and interesting comments.
Seems it all comes down the the speed of the network.
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.
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.
ASKER
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.