MySQL Forums
Forum List  »  Microsoft Access

Re: can't import /export tables from MYSQL to Access
Posted by: Markus Zimmermann
Date: October 21, 2005 02:37AM

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.

Options: ReplyQuote

Written By
Re: can't import /export tables from MYSQL to Access
October 21, 2005 02:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.