This is a simple MS Access 2003 Project file (*.adp). It accesses a
SQL Server 2005 database on the network. It has 10 tables.
Everything updates, deletes, inserts, adds without a hitch, except for
the issue(s) below.
When I make a selection from the combo box and move to another object
or close the form I get the following error:
(error 1) "Key value for this row was changed or deleted at the data
store. The local row is now deleted." I hit the "OK" button.
It takes me back to the form.
If I close the form, I get this error:
(error 2) "Multiple-step operation generated errors. Check each
status value" I hit the "OK" button.
Another alter box appears saying, "You can't save this record at this
time. <Application Namemay have encountered an error while trying
to save a record. If you close this object now, the data changes you
made will be lost. Do you want to close the database object anyway?"
<Yes<No>
I hit "Yes" the alert box appears again.
I hit "Yes" again. Another alert box appears with this error message,
"Another user or application has deleted this record or changed the
value of its primary key."
Error 2 appears again. I hit the "OK" button and the form disappears.
I look at the data in the table and the new information has been saved/
committed. When I open the form again the data I just entered (after
the errors) is there and in the tables (obviously).
Thoughts? Suggestions?