RE: MS Access 97 connection to MySQL

[Michael Widenius]

<cut>

barry> Dear Jani, 
barry> Thank you for your help. 
barry> Just made another test. I found that I can add/update/delete
barry> the tables entry AFTER I drop the TIMESTAMP field in the 
barry> table. It is contrary to the MySQL manual's instruction.
barry> My version of MySQL is 3.22.26a and MyODBC is v2.5


barry> rgds
barry> Barry

Hi!

How did you define the TIMESTAMP column?  To get this to work with
Access one must define is without a length modifier !

For example:

CREATE TABLE foo (a int not null primary key, b timestamp);

The following will not work:

CREATE TABLE foo (a int not null primary key, b timestamp(8));

Regards,
Monty