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.
What do you think Steve Jobs would do if he builds an Excel spreadsheet or even writes an Excel VBA program?
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.