[AccessD] Access 2003 and Windows 2003 crash. Solved

Gustav Brock Gustav at cactus.dk
Wed Jan 17 01:56:59 CST 2007


Hi all

This is a bug:

http://bugs.mysql.com/bug.php?id=9932 

This is one solution which sports the little known feature using a file named msaccess.exe.local, and it will even if a later Windows service pack (SP2?) should be installed:

---
[19 Sep 2005 11:44] Jean-Nicholas Harvey 

1 - Go to the msaccess.exe folder (e.g. C:\Program Files\Microsoft Office\Office)
2 - Create an empty file named msaccess.exe.local
3 - Copy a working version of MSJET40.DLL (earlier than 4.0.9025.0) in this folder

This should work even if people is in charges of the updated is incensed in installing the roll-up patch or if Microsoft decide to update the MSJET40.DLL for another time.

---
[14 Jan 23:55] Daniel Kasak 
Search on this page for '.local'. This method seems to work best for us, and survives successive Windows Update operations.

---
The other option is to replace MSJET40.DLL with version 8618 or older:

---
[1 Jul 2005 12:32] Erik van Uffelen 

Essence is to replace ONLY the MSJET40.DLL file with an older version.

Windows System File protection protects the msjet40.dll file when you try to replace it with an older version. 
How to fix this issue:

1. Disable system file protection (not very neat) or...
2. Make sure systemfile protection uses the old MSJET40.dll file

Option 2 is preferable to me.  I'll explain how:
1.  Go to %SystemRoot%\system32\dllcache (it is a hidden system folder) and replace MSJET40.dll with the old version (4.0.8618.0)
2. Go to %SystemRoot%\system32 and also replace the MSJET40.dll file.

This must be done in the specified order.
Now SFP thinks the file is correct and will not replace it.

---
The last method is described here as well:

http://forums.mysql.com/read.php?37,40799,87744#msg-87744 

/gustav

>>> Gustav at cactus.dk 16-01-2007 17:21 >>>
Hi all

A client is trying to install Access 2003 SP2 on his Windows 2003 Standard Server SP1 with MySQL 3.51.12 ODBC driver.
Windows Update has updated the server OS.

>From Excel he can open a connection to the MySQL and read the data off the tables.
When he tries that with Access it crashes as soon as he tries to open an attached MySQL table. No errors, just poof.

What gives? Any ideas?

/gustav




More information about the AccessD mailing list