MySQL Bugs: #16715: Linking MySql Table with Microsoft Access

Bug #16715	Linking MySql Table with Microsoft Access
Submitted:	22 Jan 2006 22:48	Modified:	24 Jan 2006 2:55
Reporter:	Denis Desjardins	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:		OS:	Windows (XP x64)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any

Description:
Hi,

I follow the explanation of Peter Harvey on bug error: 12255 and succesfuly setup a connection with the 32 bit driver. The problem come after when it is time to link new table or refresh link already connected to Access I receive this message:

<<Microsoft Office Access has encountered a problem and needs to close.>>

Thanks
Denis Desjardins

How to repeat:
Each time I try to link or refresh a table I get error :
<<Microsoft Office Access has encountered a problem and needs to close.>>

CLIENT SIDE:
DELL DIMENSION 9100
Intel Pentium D processor 830 32 GHz (dual-core)
800 MHz front-side bus 
2 x 1 MB L2 cache (1 MB per processing core)
Intel 945P Express chipset
1 GB dual channel DDR2 SDRAM at 533 MHz (2 x 512 MB)

Microsoft Windows XP Pro x64 Edition Version 2003 Service Pack 1
Microsoft Office Access 2003 (11.6566.6568) SP2
Microsoft ODBC 32bit 3.526.1830

Microsoft Jet 4.00.9025.0 on C:\WINDOWS\SysWOW64
MDAC 2.8 SP2 

myODBC 3.51.12

I download mysql-connector-odbc-3.51.12-win32.msi and I try the mysql-connector-odbc-3.51.12-2-win32.msi with no success.

SERVER SIDE:
Microsoft Windows Server 2003 SP1
MySQL 4.1.12 via TCP/IP

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

It's a well-known problem of msjet40.dll version 4.0.9025.0. Would you find another version of msjet40.dll?
msjet40.dll version 4.0.9025.0 is from one of the latest windows updates, then there should be a backup of the pervious version.
It should be somewhere on your disk. Versions 4.0.8015.0 or 4.0.7328 are suitable.

Current version of msjet40.dll is located in Windows/system32 directory. It is protected by Windows file protection. Therefore you need to replace msjet40.dll in Windows/system32/dllcache directory and Windows/system32 directory.

Sorry, forgot to tell: my previous message described how to fix that for win32. For win64 you need to look for msjet40.dll in Windows\Syswow64 directory

Hi Bogdan, 

I follow your indication and the info on bug # 9932 to install the msjet40.dll 
(The section of Jean-Nicholas Harvey work the first time).

Work nice on the XP x64

Thank You
Denis Desjardins