If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error message when adding a new record
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Error message when adding a new record
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. |
Thread Tools | |
Display Modes | |
|
|