Form with MySQL linked tables showing #DELETED for new records

[Sean]

This is with Access 2003 in 2000 mode.

I have a number of fairly simple forms based on some linked MySQL tables.
Whenever I add a new record using the forms all the fields display
"#DELETED" until I close the form and re-open it, the fields then appear as
added.

Any ideas? TIA

 

[Sean]

This is with Access 2003 in 2000 mode.

I have a number of fairly simple forms based on some linked MySQL tables.
Whenever I add a new record using the forms all the fields display
"#DELETED" until I close the form and re-open it, the fields then appear
as added.

Any ideas? TIA

NM found the solution myself.

It appears to be that MySQL auto increment fields were the problem as they
update on the server and the new value does not get returned to Access. The
solution was to create a text field in Access linked to the auto increment
field and set it's default value to 0. This does not affect the real field
value but magically solves the #DELETED problem.