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.


----- 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 "" 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.

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