Category Archives: Access

FW: Using Database Library Files in Your Access Application

Andrew Wrigley based in Argentina and the UK wrote an really good article to describe how to use Database Library Files in Access application. I found it is very useful and solved a lot of my problem. Below is the … Continue reading

Posted in Access, VBA/ASP | Leave a comment

Migration Access database to MySQL

A couple of years ago, MySQL provided MySQL GUI Tools Bundle. Somehow, they decided to stop working on the bundle and started developing MySQL WorkBench. Now the Workbench works pretty good and the functionality is getting rich. I use it … Continue reading

Posted in Access, Database, MySQL | Tagged , , | Leave a comment

Solve an issue encountered when SpotFire read Microsoft Access database

Situation: SpotFire read data from an Access database for generating graphs. An error message always pops up and says: Error message: The required OLE DB provider (Microsoft.ACE.OLEDB.12.0) for Microsoft Access is not installed  Solution: Download Microsoft Access Database Engine 2010 Redistributable … Continue reading

Posted in Access, Software, Tips | Tagged , , , , | Leave a comment

A skeleton of a MS Access VBA function operating data tables

Use Microsoft Access VBA can do all sorts of database operations. The following is the framework of a VBA subroutine. It includes all VBA database operation mechanisms. You can just borrow it and adapt it to your situation. Sub FillAField(tablename) … Continue reading

Posted in Access, VBA/ASP | Tagged , , , | Leave a comment

SQL in MS Access 2007

Microsoft Access 2007 is a powerful tool to handle data, large or small, simple or complex. Recently I was forced to use it to do something because the data source was stored in an Access database. It comes out that … Continue reading

Posted in Access, Programming | Tagged , , , , , , , | Leave a comment