List:MySQL ODBC« Previous MessageNext Message »
From:Pat Sherrill Date:May 5 2001 11:24am
Subject:Re: ODBC wit Access2000
View as plain text  
Also ensure you have a Primary Key (auto_increment has been most effective
in my experience).
Pat...

----- Original Message -----
From: "Robert Goeres" <rg@stripped>
To: "'Armin Schöffmann'" <armin.schoeffmann@stripped>
Cc: "mysql liste myODBC (E-mail)" <myodbc@stripped>
Sent: Saturday, May 05, 2001 6:53 AM
Subject: RE: ODBC wit Access2000


> I checked "Return Matching Rows" option
> I added a column of type TIMESTAMP[14]
>
> but still I can not update the table?
>
> -----Original Message-----
> From: Armin Schöffmann [mailto:armin.schoeffmann@stripped]
> Sent: jeudi 3 mai 2001 20:55
> To: Robert Goeres
> Subject: RE: ODBC wit Access2000
>
>
> Set the "Return Matching Rows" option when connecting from access.
> Access wants to see atleast one column of type TIMESTAMP[14] to do proper
> updates.
> There may be some conflicts with the datatypes in your table, too. Refer
to
> section "MySQL ODBC Support - Programs Known to Work with MySQL" in the
> manual.
>
> ASC.
>
> -----Original Message-----
> From: Robert Goeres [mailto:rg@stripped]
> Sent: Thursday, May 03, 2001 6:44 PM
> To: mysql liste myODBC (E-mail)
> Subject: ODBC wit Access2000
>
>
> I installed myODBC 2.50.37 connected it to mySQL and linked tables in
> Access2000 to mySQL.
> I can read the tables. When I want to update the tables, I get a write
> conflict and can not force it and Save the record. Creating a new record I
> get the same message but I can notice that the record has been created in
> mySQL. I also have trouble to get out of access?
>
>
> Best Regards
> Robert Goeres
> robert.mailling@stripped
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread3238@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.
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread3244@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
ODBC wit Access2000Robert Goeres3 May
RE: ODBC wit Access2000Robert Goeres5 May
  • Re: ODBC wit Access2000Pat Sherrill5 May
RE: ODBC wit Access2000Robert Goeres5 May