cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Check out the Dropbox cheat sheet for getting started in 2021 here!

Dropbox files & folders

Get in sync with the Dropbox Community. Our members can answer all your questions on Dropbox files and folders. Join a discussion or start your own today.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Sharing Access database

Sharing Access database

New member | Level 1

I would like to share an Access database with other users. It works on Dropbox in exclusive mode, not in multiuser mode. How else can I do it if Dropbox is not a good platform? I need a low tech solution.

 

Suzanne

1 Accepted Solution

Accepted Solutions

Re: Sharing Access database

Super User II

Argh! No. Dont do it!

It WILL go wrong. It WILL lose you data and it WILL cause you to spend hours fixing it.

As a side note it cannot do 'multiuser mode' because you've forgot the simple fact that every single user of the folder would have there own individualised copy of the database. They'd all be working on each of there own versions - there is NO central place to work on stuff in Dropbox. 


 


- - -


Heart Did this post help you? If so please mark it for some Kudos below. 


 Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.


 Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible! 


 

View solution in original post

4 Replies 4

Re: Sharing Access database

Super User alumni

Dropbox should not be used as a network transport layer for any database, it simply wouldnt reliably work and will end in tears.

You arent really going to be able to accomplish what you are after with a "low tech solution". You need a proper network aware solution such as swapping out your Access backend for SQL Server - you can keep using Access as the front end, but you cant do what you want with Access as the backend.

Re: Sharing Access database

New member | Level 2

I agree with Richard.  I tested this with another cloud storage platform a few years ago when I needed to share an Access DB with users at other locations.  There is no good way to do this.  It exceeds what MS designed Access for.  Sharepoint can better handle this.

In a Corporate setting, Access db's can reside on a shared drive and mange multiple users editing directly and simultaneously.   If you store Access db on Dropbox, Dropbox will not be able to open it.  It would force you to open it in a locally installed Access client to edit.  This will cause problems or corruptions of links and references in tables. 

If you have each user work off copies stored in their local Dropbox folder, users can unknowingly overwrite others changes during sync.  You end up having to ask "are you working in the db?".

Re: Sharing Access database

Super User II

Argh! No. Dont do it!

It WILL go wrong. It WILL lose you data and it WILL cause you to spend hours fixing it.

As a side note it cannot do 'multiuser mode' because you've forgot the simple fact that every single user of the folder would have there own individualised copy of the database. They'd all be working on each of there own versions - there is NO central place to work on stuff in Dropbox. 


 


- - -


Heart Did this post help you? If so please mark it for some Kudos below. 


 Did this post fix your issue/answer your question? If so please press the 'Accept as Solution' button to help others find it.


 Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible! 


 

View solution in original post

Re: Sharing Access database

New member | Level 2

Agreed^^.. .  .   .    .     your are better off just rockin it with good communication through dropbox and keeping access for heavy hitting....but if security and reliability aren't an issue :winking face with tongue: maybe??

 
[This thread is now closed by moderators due to inactivity. If you have a similar or new question, you could post it in the Find Answers section here. ]
Polls
Do you use Dropbox for work, personal use or both?
Tell us your thoughts?

Work Smarter with Dropbox

The way we work is changing. Share and discover new ways to work smarter with Dropbox in our community.

Sound good? Let's get started.
Who's talking

Top contributors to this post

What do Dropbox user levels mean?
Need more support?