List:MySQL ODBC« Previous MessageNext Message »
From:Pat Sherrill Date:August 17 1999 10:58am
Subject:Re: Unable to Update *SOME* Records
View as plain text  
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.
>
>

Thread
Unable to Update *SOME* RecordsMichael Houlahan17 Aug
  • Re: Unable to Update *SOME* RecordsPat Sherrill17 Aug
    • Re: Unable to Update *SOME* RecordsMichael Houlahan18 Aug
Re: Unable to Update *SOME* RecordsMichael Houlahan18 Aug