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?
LVL 1
dabug80Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MacroShadowCommented:

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.
http://www.access-programmers.co.uk/forums/showthread.php?t=227648
http://answers.microsoft.com/en-us/office/forum/office_2013_release-access/access-multi-users-in-db-at-the-same-time-created/2375fe3e-41ca-4abe-9408-cee5f55625da?msgId=f5edc3ca-7220-4d9f-86d2-810b59379dc4
http://www.amphis-software.com/crm-database-dropbox.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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
0
dabug80Author Commented:
Thanks for your help. I'll have to keep the database on a LAN and disable shared cloud backups
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.