Form with MySQL linked tables showing #DELETED for new records

  • Thread starter Thread starter Sean
  • Start date Start date
S

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 said:
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
Click to expand...

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.
 
Back
Top