It would appear that MS Access is attempting discover the 'uniqueness' of a
row/record after being marked 'dirty'. A TIMESTAMP(14) column is readily
identified by the underlying Jet DB engine used by Access.
Searching the archives will yield quite a bit about this issue. It is the
manner in which Jet approaches 'dirty' and 'unique' as opposed to the ODBC
and MyODBC interface.
A simple ALTER TABLE command added an AUTO_INCREMENT column and a
TIMESTAMP(14) column will relieve your headache.
I hope this helps...
Pat...
[EMAIL PROTECTED]
----- Original Message -----
From: "Wojciech Spychała" <[EMAIL PROTECTED]>
To: "'Pat Sherrill'" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 7:08 AM
Subject: RE: ODBC trouble - please help
> time_stamp ???
> what is this for?
>
> -----Original Message-----
> From: Pat Sherrill [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 12:58 PM
> To: Wojciech Spychała; [EMAIL PROTECTED]
> Subject: Re: ODBC trouble - please help
>
>
> Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an
> AUTO_INCREMENT field).
> Pat...
>
> ----- Original Message -----
> From: "Wojciech Spychała" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 07, 2001 4:14 AM
> Subject: ODBC trouble - please help
>
>
> > I 've got problem with ODBC support for Microsoft Access
> > Very ofeten i can't edit records because one error. ODBC driver says
> "there
> > is another user editing same record in this time"
> > This isn't true - because i work alone :-(
> >
> > Is anyone who can help me?
> >
> > Thanks
> > Wojtek
> >
>
---------------------------------------------------------------------
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
