Link to home
Start Free TrialLog in
Avatar of dabug80
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?
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

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
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
Avatar of dabug80
dabug80

ASKER

Thanks for your help. I'll have to keep the database on a LAN and disable shared cloud backups