Prev: Microsoft Responds to the Evolution of Online Communities
Next: Autoincrement
From: forest8 on 5 May 2010 11:19
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.
From: Dorian on 5 May 2010 11:44
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.
From: KARL DEWEY on 5 May 2010 11:44
You have setup some sort of relationship between the student record table and
'T_Community Contacts'. The entry of a new student record is not satisfying
that relationship.

--
Build a little, test a little.


"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.
 | 
Pages: 1
Prev: Microsoft Responds to the Evolution of Online Communities
Next: Autoincrement