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
