MyODBC Claims "annother" is updating same data?

------=_NextPart_000_001B_01C51DCD.60CD5DE0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi All,



New to this list - let's see if someone can help me out.



I've tried 3.51.11, 9, 10 and 12-2 . with no luck.



When I link Microsoft Access to my server and try to update a record - I get
an error message that states, "this record has been changed by another
user." and doesn't allow me to update the record.



I've seen this error - but, I haven't seen a decent explanation or fix.



Help? Suggestions?? Please!!!



(db)

------------------------------------------

Daniel Bohner

ExistingLight, LLC

http://www.existinglight.net

drbohner@existinglight.net

drbohner@gmail.com

Home Office: 208.467.3316

mobile: 208.250.1917

fax: 208.246.3425

------------------------------------------

XBOX Gamer-Tag: drbohner

MSN IM: drbohner@existinglight.net

Yahoo IM: drbohner@yahoo.com

------------------------------------------




------=_NextPart_000_001B_01C51DCD.60CD5DE0--

RE: MyODBC Claims "annother" is updating same data?

Daniel:

Add a column to the table type timestamp. This will allow msaccess the
information it's need no know that nobody is modifying the record.

If you have msaccess as a frontend and mysql as you backend, then put
the timestamp on every table you have in the mysql.

Osvaldo Sommer

-----Original Message-----
From: Daniel Bohner [mailto:drbohner@existinglight.net]
Sent: Monday, February 28, 2005 8:41 PM
To: myodbc@lists.mysql.com
Subject: MyODBC Claims 'annother' is updating same data?

Hi All,



New to this list - let's see if someone can help me out.



I've tried 3.51.11, 9, 10 and 12-2 . with no luck.



When I link Microsoft Access to my server and try to update a record - I
get
an error message that states, "this record has been changed by another
user." and doesn't allow me to update the record.



I've seen this error - but, I haven't seen a decent explanation or fix.



Help? Suggestions?? Please!!!



(db)

------------------------------------------

Daniel Bohner

ExistingLight, LLC

http://www.existinglight.net

drbohner@existinglight.net

drbohner@gmail.com

Home Office: 208.467.3316

mobile: 208.250.1917

fax: 208.246.3425

------------------------------------------

XBOX Gamer-Tag: drbohner

MSN IM: drbohner@existinglight.net

Yahoo IM: drbohner@yahoo.com

------------------------------------------




--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.1 - Release Date: 2/27/2005


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.1 - Release Date: 2/27/2005



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC Claims "annother" is updating same data?

Daniel. Did that solution work for you? I've received this error / alert as
well when multiple people are adding new records to a SQL Database using
MSAccess 97. I wonder if I should add this field to my SQL table.

-Chris



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org