List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:March 4 2000 4:40pm
Subject:Re: Using MS Access 97/2000 with MySQL and MyODBC driver
View as plain text  
Miguel
I have been using Access 2000 to open and edit MySQL tables.  The only
problem I encounter is if there blank fields in any records.  If this is
the case then I get the "Write Conflict" error.  For example, I have a
field in a table GROUP_ID char(2).  The field is unused.  If I leave it
blank then I get the error.  If I fill all the records with a character
then I don't get the error.


At 11:00 PM 3/3/00 -0300, miguel solórzano wrote:
>03/03/2000 22:17:37
>
>Some users of MS Access has found problems with the columns
>of the types date, time and timestamp. To resolves this problem
>the tip there is in the DSN file setup.
>
>The setup form of MyOBC driver will be fill as follows:
>
>Windows DSN name   <the name that you wants ie: mytest>
>
>MySQL host (name or IP)   <ie: 192.168.0.1>
>
>MySQL database name   <the name of your MySQL database ie: mydb>
>
>User  <the name of the user used on the GRANT TABLES>
>
>Password  <password of the user above>
>
>Port (if not 3306)  <left blank if you are using the default port>
>
>On the options that affects the behavior of MyODBC,  you must click the
two options below:
>
>Return matching rows
>Use manager cursors (exp)
>
>The last two option resolves the problem.
>
>Regards
>Miguel
>
>+----------------------------------------------------------------------+
>| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
>|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Miguel A. Solórzano         |
>|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:miguel@stripped     |
>|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     São Paulo - Brazil          |
>|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
>|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
>|             /*/             \*\                Developers Team       |
>+----------------------------------------------------------------------+
>
>
>
>-- 
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread30042@stripped
>
>To unsubscribe, send a message to:
>    <mysql-unsubscribe-cj=interlog.com@stripped>
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped


Thread
Using MS Access 97/2000 with MySQL and MyODBC drivermiguel4 Mar
  • Re: Using MS Access 97/2000 with MySQL and MyODBC driverGraeme B. Davis7 Mar
Re: Using MS Access 97/2000 with MySQL and MyODBC driverChristopher R. Jones4 Mar