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
]]
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
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
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
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