Re: can't import /export tables from MYSQL to Access

[Markus Zimmermann]

Thanks to Roger Asbahr!! Finaly it works!

After replacing the msjet40.dll to the older version fixed my problem


He wrote:

Here's the answer as posted by Jackson Taylor. If you're replacing the msjet40.dll on Windows 2003 you'll need to work around "Windows File Protection".

Re: Problems creating linked table in Access
Posted by: Jackson Taylor (IP Logged)
Date: August 11, 2005 08:44AM

Some more info... found by searching this site (not sure how I missed it before)...

after installing the "Update Rollup 1 for Windows 2000 Service Pack 4 (KB891861)" every attempt to update or add linked odbc tables crashes Access (using the existing data link seemed fine). They updated msjet40.dll (7/19/2004), and it seems to not play well with the odbc program. Replacing the dll with the previous version (3/1/2004) fixed the problem.

Thanks Jackson, worked like a charm.