Hi !! > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 21, 2002 11:52 PM > To: [EMAIL PROTECTED] > Subject: MySQL, MyODBC and MS Access > > > Hello! > > You are my last chance, reading FAQs and asking in newsgroups > gives no effect. > > I have a problem when connecting a MySQL table in MS Access > (2000) through MyODBC. > > MySQL is ver. 3.23.44 running on FreeBSD 4.5 box. > > Description of the problem: > > I connect the table and Access correctly retrieves data. But > when user tries to add data or to change any field, access > performs an error box that "some another user has changed > this field when you were changing it", but actually nobody > was connected to MySQL at that time. This problem takes place > only in Windows'98. When I perform the same operation from > Windows XP all is correct. Maybe I have to make some > additional settings for MyODBC (version > 2.50.39-win95) in Windows98? Please help. > > Thanks in advance!
You should set the OPTION=2. I think its listed in the FAQ too. Coming to XP, whats your Access version on XP ? (that might be a latest version, which has many fixes towards ODBC that exists in older versions :) Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php