Hi I have been experiencing the following error when using MyODBC in Windows 2000 within Microsoft Access 2000 with MDAC Component 2.7:
ODBC--call failed [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) (#1045) The thing I can't understand is the problem does not always occur, only sometimes - and I known that I am entering the correct password, because like I said sometimes it will work and sometimes it won't, and I have been using the same password on other machines when logging in as root. The permissions table should be set to allow any hostname to connect as i entered root@% as the hostname. I cannot distinguish between times when the error will occur, and times when it will not - it usually only happens on one or two tables in the database, and pretty much always when I try to add a new link table in MS Access. I have tried it with and without the "Safety" check box checked. The IP is 217.199.170.217, database: orders, logging in as user "root" on port 3306. Any help that could be provided would be greatly appreciated, this is causing me major problems, and I've got a deadline approaching!! Cheers Joe --------------------------------------------------------------------- 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