I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, the database name of "metrics" and port 3306. I had to setup the privileges very carefully in the MySQL user table and to spell my database name correctly in order to make it work. Rodrigo Antonio Reyes Cabrera wrote: > Hi > I am using Access 2000 and I would like to configure it in order to use it > as a interface to a mySQL db. Is this possible? I think it is, but I haven't > been able to get it done so far. I am using the myODBC driver, but I get > error messages when I try to import or link a table from my db into Access. > Nevertheless, I can connect from PHP using the same ODBC connection. What > could be wrong? > > Rodrigo > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- 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