Forum Discussion
Constant database conflicts
We operate a small law office. We have used Access for our client database for many years and it worked well for us until Covid lockdowns started. The primary data file is saved as .accdb file and ...
This is a very bad idea.
Clouds services are not intended for multiuserjobs, ask youself how access works: it open the accdb file, read and write and eventually close the file, at that moment dropbox (or onedrive or whatever you have) upload your file on the cloud and other users download the accdb file.
What do you think happen when two or more user modify their local copy of the accdb file at the same time?
You need a vpn for all users (not vpn for privacy, your own vpn installed at your office), so they can connect directly to the accdb file in your server/pc at the office.
Ciao
Clouds services are not intended for multiuserjobs, ask youself how access works: it open the accdb file, read and write and eventually close the file, at that moment dropbox (or onedrive or whatever you have) upload your file on the cloud and other users download the accdb file.
What do you think happen when two or more user modify their local copy of the accdb file at the same time?
You need a vpn for all users (not vpn for privacy, your own vpn installed at your office), so they can connect directly to the accdb file in your server/pc at the office.
Ciao