Using Access with Dropbox

So you've noticed that Access doesn't play well with Dropbox? Because Dropbox uses a synchronization process to put a local version on your desktop, all kinds of nastiness can happen. Your data can overwrite another person's data when you synch back to drop box. Your Database structure changes may conflict with someone else's changes. And of course there's a host of corruption errors we've seen occur.

Solution? Don't use drop box but instead move your data file to MySQL or SQL Server. We prefer MySQL because it's FREE. It has all the features you as an Access Developer/User need. It will hold an immense amount of data (far more than Access), and it is powerful and fast.

So what do you do? Get MySQL onto your webserver or contact us and we'll host your data file on our MySQL Server.

Create your tables in MySQL and migrate your data (there's a wizard for this, or we can do this for you).

Delete your tables in Access and connect your tables to MySQL (You'll need a driver for your workstations that is a free download from Oracle. Make sure you get the proper version: 32 bit or 64 bit depending on your WORKSTATION's operating system). Put in a couple of lines of code to check/relink to the MySQL Server upon startup. We can do this for you or you can look it up on google.

That's it. Now you are properly in the cloud with your Access database and you can share your database worldwide.

Want to learn about more solutions? Access and Outlook: https://www.datacontrolllc.com/microsoft-access-solutions-for-outlook-and-access

We are also PHP and MySQL developers. To find out more, go here: Data-Bolt.com PHP and MySQL developers and programmers for web applications

Here are some clients we have helped:



Project Description

Commonwealth Computer Training , Commonwealth Computer Training has referred us and subcontracted us to a number of their clients including the French Insurance Giant: Allianz. We have provided Access database development and mentorship.

From Commonwealth's website: Commonwealth Computer Training (CCT) opened in 2001 as the technology training division of Commonwealth Personnel Consultants, Inc., Patricia W. Haynes, a Certified Personnel Consultant, co-founded Commonwealth Personnel Consultants in 1985. It is one of the first female owned and operated recruiting firms in the Richmond, Virginia area. CCT is a SWAM certified business.

Commonwealth Computer Training


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Our Process

  1. Discovery Conversation
  2. Agree to scope of work
  3. Test plan creation
  4. Iterative database development with client input
  5. Database rough draft delivery
  6. Database final implementation
  7. Database user documents
  8. Database developer documents