In the last episode (Jul 13), Kevin Smith said:
> Yes, each record has a primary key, but not a timestamp. Does this
> make any difference?
>
> This also happens with my Unix machine which has MySQL installed on
> it. I have had the problem for about a year, but now that I'm
> starting to use MySQL in real-time applications I'm developing at
> work, this is a real bug bear and one that I'm surprised no one knows
> about.
We do know about it, and it's in the manual :)
http://www.mysql.com/doc/M/y/MyODBC_clients.html
To make Access work:
* You should have a primary key in the table. If not, new or
updated rows may show up as `#Deleted#'.
* You should have a timestamp in all tables you want to be able
to update. For maximum portability `TIMESTAMP(14)' or simple
`TIMESTAMP' is recommended instead of other `TIMESTAMP(X)'
variations.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php