MS Access Conflicted Copy


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?
Who is Participating?
MacroShadowConnect With a Mentor Commented:

The backend database file is shared on Dropbox.
Means that each user is working on separate copy that was downloaded to his computer. The one updated last "wins" over all the other copies, and all the other users' copies are lost.

Sorry but Dropbox isn't the right way to share an Access file be it front or back end.

See these links for a discussion and alternative to using dropbox.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Unfortunately Dropbox just does not work for sharing an Access database between users.

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
dabug80Author Commented:
Thanks for your help. I'll have to keep the database on a LAN and disable shared cloud backups
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.