Form with MySQL linked tables showing #DELETED for new records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 17 Oct 2005 15:41 GMT

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

Reply to this Message

Sean - 17 Oct 2005 15:53 GMT

> This is with Access 2003 in 2000 mode.
>
[quoted text clipped - 4 lines]
>
> 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.

Reply to this Message