All,

Yo gang! Having a problem with the MySQL ODBC 3.51 driver.

I've got a MySQL volume which has a user table (tbl_usr). I'm linking this
table to an Access database on my workstation (via ODBC link). The account
being used for the connection has select, update, and insert rights to all
tables in the database.

I'm populating the linked (MySQL) table with data I've got on my workstation
in an MS Access database. To do this, I'm simply executing an "insert into
... select ... from" statement.

INSERT INTO tbl_usr (fst_nm, lst_nm, tle_nm, email_addr)
       SELECT tbl_stage.First, tbl_stage.Last, tbl_stage.Title,
tbl_stage.Email
          FROM tbl_stage;

However, each time I execute the statement I receive an error (see attached
file - mysql_odbc_err.pdf). The error message provided isn't very helpful.
Can anyone elaborate?

Client Environment:

 - Windows 2000 (SP3)
 - MS Access 2000

Server Environment:

 - MacOS X 10.2.6 (Jaguar)
 - MySQL 4.0.13-standard

Regards,
Adam

 <<mysql_odbc_err.pdf>> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to