This article is a set of complete instructions on how to link a Microsoft Access database front to an MYSQL database hosted on a webserver. We start you from ground zero and build it up to the top.
Time and again I have found that the humble Microsoft Access database can serve the needs of resource-strapped SMEs perfectly. Let me explain the 6 reasons why.
A local airport operator seek us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using iPads and the results are stored in an Oracle database.
A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships.
A commodity trader approached us to create an Excel VBA database application to store and manage trading records.
In every project we undertake, we are always held hostage by two constraints: “time” and “quality”.
As development consultants, we often get the question: “Should we do this project in Access or Excel?”.
Having worked as an independent contractor for Excel VBA development for a number of years, I would like to share some useful experiences for people who drop by my site and prospective clients.