Hi Juergen
As Pat suggested, please add a Timestamp(14) field to your tables (even if
you feel you do not need a timestamp, or if you already have a date field in
the table). For some reason, Access/ ODBC requires it.
David
-----Original Message-----
From: Juergen Hoffmann [mailto:jh@stripped]
Sent: Friday, July 23, 1999 11:09 AM
To: Patrick Sherrill
Cc: Juergen Hoffmann; myodbc@stripped
Subject: Re: Problems with Access 97
On Fri, Jul 23, 1999 at 10:25:27AM -0400, Patrick Sherrill wrote:
> Make sure you have a TIMESTAMP(14) and a PRIMARY KEY in the table.
>
> Pat...
>
> > Hello,
> >
> > I know some of you might think it is a stupid question, but I have a
> problem
> > with MS Access 97 and Mysql on Debian Linux 3.21.xx
> > If I try to insert or update data in some records Windows prompts with
the
> > Error message, that some other user is currently working in this record,
> > although I am the only one connected to the server???
> >
> >
It concerns a field of the type DATE and a primary key is set. The TIME
Field in the same record is writable to... :-(
kind regards
--
Mit freundlichen Gruessen
Juergen Hoffmann
--
my quote of the day:
TeX is potentially the most significant invention in typesetting in this
century. It introduces a standard language for computer typography, and in
terms of importance could rank near the introduction of the Gutenberg
press.
-- Gordon Bell
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread462@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.
