17 messages in com.mysql.lists.mysqlMyODBC 2.50.37 and Access 2000
FromSent OnAttachments
Rolf Hopkins12 Jul 2001 23:55 
John Birrell13 Jul 2001 00:04 
Jorge del Conde13 Jul 2001 00:15 
Chris Bolt13 Jul 2001 01:46 
Rolf Hopkins13 Jul 2001 01:58 
David Bouw13 Jul 2001 02:15 
Kevin Smith13 Jul 2001 02:24 
Kevin Smith13 Jul 2001 08:37 
Venu Anuganti13 Jul 2001 08:43 
Don Read13 Jul 2001 08:47 
Joshua J. Kugler13 Jul 2001 14:30 
JHDr...@saginawcontrol.com13 Jul 2001 14:42 
Kevin Smith13 Jul 2001 14:43 
Kevin Smith13 Jul 2001 14:49 
Kevin Smith13 Jul 2001 15:12 
Dan Nelson13 Jul 2001 15:41 
Sinisa Milivojevic14 Jul 2001 04:01 
Subject:MyODBC 2.50.37 and Access 2000
From:Kevin Smith (kev@netsmith.ltd.uk)
Date:07/13/2001 02:24:03 AM
List:com.mysql.lists.mysql

Hi All,

I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am currently developing a database using Access 2000 as a front-end to MySQL using MyODBC 2.50.37.

I have all my MySQL tables linked as ODBC tables in Access.

When I am inputting data into an Access Form and then save the record, all the fields are changed to #DELETED. The record data is saved I know, but why do the fields all change to #DELETED when the record is inserted into the MySQL table? Is there a fix for this, or, it is just the case of using ADO to do the insert and just refresh the Access Form to then move to the record itself... a bit of a pain though...

Any ideas?

Many thanks,

Kevin Smith