View Single Post
  #2  
Old May 5th, 2010, 04:44 PM posted to microsoft.public.access.gettingstarted
Dorian
external usenet poster
 
Posts: 542
Default Error message when adding a new record

The message means exactly what it says. You must have a table relationship
defined and the changes you made to the record must have conflicted with the
defined relationship.
Check what table relationships are defined for those 2 tables.
You will need either to change the relationship or to add some code to your
form to check for that condition and put out a more meaningful message.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"forest8" wrote:

Hi

This is the situation:

In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:

“The record cannot be deleted or changed because table ‘T_Community
Contacts’ includes related records” OK or Help were the only options.

My user checked the Community contacts tab and there was nothing in it.


After that, everything she clicked on brought up that message. When she
tried to close the program, it popped up again. She clicked ok and got the
following message:

“You can’t save this record at this time Microsoft Office Access may 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


She clicked yes, closed and reopened it. None of the new names were there,
but changes to existing records had been saved.

What does this error mean and how do I fix it?

Thank you in advanced for your help.