Unable to insert records in a query result using Access

Hi,
This is a strange problem. I have two copies of the same access MDB, the
only difference being that one MDB knows about the timestamp column I
just created in MySQL while the other MDB's table links haven't been
synchronized to reflect this fact. So one knows about timestamp, the
other doesn't. In the one that knows about timestamp, I cannot insert
records into the query result. The add record button at the bottom is
greyed out. I tried adding all fields to the query including the primary
key. That made no difference. In the table that cannot see the
timestamp field, I can add records just fine. Note that in both MDBs I
can insert records directly into the table. The columns are varchar.

Mysql 4.1.1
Access 2000

Thanks,
CJ


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org