MS Access and MySQL

From DreamHost

Keeping MS Access from Crashing

If you want to use MS Access and MySQL on dreamhost here what you need to do to stop MS Access crashing, which by default it does.

First head to this link:

http://support.microsoft.com/kb/239114/

There you'll find the files that contain the a version of msjet40.dll - extract this file, version 4.0.8015.0

After that go to: C:\Program Files (x86)\Microsoft Office\OFFICE11 for X64 C:\Program Files\Microsoft Office\OFFICE11 for X32

(office11 is the name for the 2003 version, you may see another name)

copy the dll into this directory, after which MS Access will connect.

This should work if you have norton on/off, Avast etc. and works with Access 2003, Access 2000, win 2000, xp, x64, server products too. This also works with the latest version of the mqsql-odbc download.

Another Option I have had relatively easy success using MySQL's ODBC connection tool, which can be downloaded from [1]. I also didn't need to update the jet database as described above (on a computer purchased in early 2008).

Access Quirk

You may have bool's in your mysql db, if you set the values of these to be -1 or 0, and connect via access, it will show you checkbox columns.

You have to ensure your application thats running uses/understands this information too.

If your application uses 1/0 true/false for all bool data entry, then ensure that you dont force these as checkbox's (access bool data type) as the values access will put in them will then be incorrect.