I'm developing a client/server application which has MS SQL Backend and MS Access frontend. I created a form based on a stored procedure which is in turn based on a JOIN query.
When I insert new record I got this error:
"Key value for this row was changed or deleted at the data store. The local row is now deleted".
After that all the fields in the form change into "#DELETE"!!!