List:MySQL ODBC« Previous MessageNext Message »
From:David Carlson Date:July 23 1999 6:20pm
Subject:RE: Problems with Access 97
View as plain text  
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.


Thread
Problems with Access 97Juergen Hoffmann23 Jul
  • Re: Problems with Access 97Patrick Sherrill23 Jul
    • Re: Problems with Access 97Juergen Hoffmann23 Jul
      • RE: Problems with Access 97David Carlson23 Jul