List:MySQL ODBC« Previous MessageNext Message »
From:Jakub Linowski Date:July 18 1999 5:11pm
Subject:RE: Access 2000 vs. Access'97 with MyODBC
View as plain text  
>Colin,
>
>My original problem was that while I could view the data in the MySQL table
>from Access 2000, I could not modify it.  Whenever I would go to save my
>modifications, an error box would pop up stating that there was a Write
>Conflict with another user and asking whether I wanted to copy my change to
>the clipboard or drop the change.  I know for a fact that no other user is
>accessing the MySQL table through ODBC or native MySQL clients during this
>process.
>
>Dan Reid
>MIS Technical Administrator
>Pilot Catastrophe Services, Inc.
>v: (334) 607-7747
>f: (334) 607-9039
>http://www.pilotcat.com
>
>



I had an identical problem a few days ago. I identified the problem / bug
in more detail. How I solved it is stated below.
The problem evolved around the DATE data type. Whe nI linked a table from
MySQL into MS Access through ODBC, and then I tried modifying the data I
received the same error as you stated above (write conflict).

This occured with MySQL:
Ver 9.16 Distrib 3.21.31, for sun-solaris2.6 (sparc)

On another computer running MySQL:
Ver 9.32 Distrib 3.22.22, for pc-linux-gnu (i686) I had no errors, and it
worked fine...


How I fixed the error on the first computer, was changed the DATE
definition into TEXT. 
I also heard that DATETIME works fine.





Thread
Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCColin McKinnon15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCStephen Dahl15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCDan15 Jul
        • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
          • RE: Access 2000 vs. Access'97 with MyODBCDan17 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCJakub Linowski15 Jul
  • Access 2000 vs. Access'97 with MyODBCMichael Widenius30 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid31 Jul
RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
  • Re: Access 2000 vs. Access'97 with MyODBCPatrick Sherrill15 Jul
    • RE: Access 2000 vs. Access'97 with MyODBCDaniel D. Reid15 Jul
      • RE: Access 2000 vs. Access'97 with MyODBCPaul DuBois17 Jul