Check your data, I think you will find a few empty records have been
created. These will get you.
Pat...
----- Original Message -----
From: Michael Houlahan <m.houlahan@stripped>
To: <myodbc@stripped>
Sent: Monday, August 16, 1999 8:18 PM
Subject: Unable to Update *SOME* Records
> Hi
>
> I have a strange problem with MsAccess connecting to MySQL via ODBC.
>
> I've got tables set up OK with Primary Key and TIMESTAMP just the way
> recommended by this list.
>
> When the table is small (<~1000 recs) things work just fine - but when I
> increase the table size to > 3000 recs, I get inconsistent results.
>
> I can update *some* records (not necessarily the first 1000) but others
> return the dreaded MsAccess dialog telling me the record was updated by
> someone else and won't let me update.
>
> I figger this has something to do with buffering - but not sure what (or
> where) I can try some config changes to fix it.
>
> Any advice??
>
> Mick
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread573@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.
>
>
