Access Database Consultant Developer Programmer

Dropbox

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:

Client

Location

Project Description

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database