I've upgraded to 4.0.6 and now MyODBC does not function properly when it used to work fine with 4.0.1. When I try to open a linked table in Access I get the error:
ODBC--Call Failed [MySQL][ODBC 3.51 Driver][mysqld-4.0.6*gamma-nt]Access denied for user: '@(My IP)' to database '(Database name here) (#1044) In order to view data through my ODBC & Access, I must delete all linked tables & "Compact & Repair Database". Then close Access & re-open the Access database and re-link the tables. Now everything is fine. BUT, if I happen to close Access, I have to repeat the whole process above because I can now no longer view data through Access and MyODBC. This never happened with 4.0.1 Alpha. Is there something new in this version that would cause this problem? I did try reinstalling MyODBC just for laughs and everything continues to act the same. Andrew --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php