Change your timestamp(6) to timestamp(14).
I hope this helps...
Pat...
----- Original Message -----
From: Frank Salinas <fs@stripped>
To: <myodbc@stripped>
Sent: Monday, May 03, 1999 1:28 PM
Subject: Can't update a table using MyODBC
> Hello:
>
> I am having a very strange problem with myODBC. I have a MySQL server
> (version 3.22.17) running on a RedHat Linux 5.2 machine. I have
> created
> links from Access 97 on a windows 98 machine to a database on the
> MySQL
> server. Everything works fine except that there is one table that
> when I try
> to update, I get the following error:
>
> "The data has changed. Another user edited this record before you
> attempted
> to save your changes. Re-edit the record"
>
> This happens even though I know I am the only one working with the
> database.
> As I said this happens with only one of the tables in the database. I
> am
> able to edit the table from the command line on the Linux machine.
> All the
> field types in this table are used in the other tables so it is not
> that
> there is some problem with an incompatible type between Access 97 and
> MySQL.
>
> Here is the description of the table.
> +--------+---------------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +--------+---------------------+------+-----+---------+-------+
> | field1 | int(11) | | PRI | 0 | auto |
> | field2 | varchar(12) | | | | |
> | field3 | varchar(255) | | | | |
> | field4 | varchar(16) | YES | | NULL | |
> | field5 | smallint(5) unsigned| | | 0 | |
> | field6 | smallint(5) unsigned| | | 0 | |
> | field7 | text | YES | | NULL | |
> | field8 | text | YES | | NULL | |
> | field9 | varchar(255) | YES | | NULL | |
> | field10| enum() | YES | | NULL | |
> | field11| timestamp(6) | YES | | NULL | |
> +--------+---------------------+------+-----+---------+-------+
>
> Any help will be greatly appreciated.
>
> Thanks.
>
> Frank Salinas
>
> Duke University.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread196@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
>
>
