Problem in connecting to mysql from MSAccess 2000

2003-07-21 Thread Gilbert Wu
Hi, I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS Excel. However, it returned the following error when I tried to link some Mysql tables from Access 2000: ODBC--call failed. [MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for user: '@my ip address

RE: MySQL and MSAccess

2002-03-13 Thread Craig Shepherd
]] Sent: 11 March 2002 20:08 To: [EMAIL PROTECTED] Subject: MySQL and MSAccess Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance

MySQL and MSAccess

2002-03-11 Thread Chris Becker
Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office

MySQL and MSAccess

2002-03-11 Thread Chris Becker
Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and

Re: MySQL and MSAccess

2002-03-11 Thread russo
Hi Chris, Also interested in exploring how MS products can interact with MySQL since I work in a diverse environment (PC's, some MACs, UNIX clusters-Solaris 8). I found this so far: http://www.mysql.com/doc/M/y/MyODBC_clients.html Also, to check which version of MDAC you have use: Component