dabug80
asked on
MS Access Conflicted Copy
Hello,
I have a split MS Access 2007 database with two front end files (for different users) which both link to the tables in one backend database file.
The backend database file is shared on Dropbox.
Forgive me but this is quite a general question as I don't know where to begin the diagnostic.
Sometimes I am finding that MS Access creates an alternate file version of the backend database tables, appending 'conflicted copy' to the newly created filename.
The two users are never entering data at the same time, so I'm not sure what is triggering this conflict. Could this be a dropbox sharing sync problem or something within MS Access that I'm missing?
I have a split MS Access 2007 database with two front end files (for different users) which both link to the tables in one backend database file.
The backend database file is shared on Dropbox.
Forgive me but this is quite a general question as I don't know where to begin the diagnostic.
Sometimes I am finding that MS Access creates an alternate file version of the backend database tables, appending 'conflicted copy' to the newly created filename.
The two users are never entering data at the same time, so I'm not sure what is triggering this conflict. Could this be a dropbox sharing sync problem or something within MS Access that I'm missing?
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 for your help. I'll have to keep the database on a LAN and disable shared cloud backups
Also there is no way to guarantee that only one person will be editing the database at a time.
See if this helps: Remote access for an Access Application