By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,972 Members | 1,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,972 IT Pros & Developers. It's quick & easy.

Error on MS Access Project when updating table

P: n/a
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?"

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?
Jan 18 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.