MS Access have an error while trying to save a record

Asked By 1660 points N/A Posted on -

Hi MS Access Savvy,

I am asking for some comments on this error message that I am posting here. I meet this error every time I update my database. 

Microsoft Office Access

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?

I have a problem solving this issue. It already caused me a lot of time looking on the internet for some solution. But it seems nothing fits to this scenario.

To all readers, please share some ideas in solving this issue. Thanks a lot.

Answered By 0 points N/A #122141

MS Access have an error while trying to save a record


The error message can be caused by several factors:

  • You might have a required field missing. Check your table definition for required fields and make sure that all of those fields are filled in before saving.
  • You might have a validation rule that is not satisfied. If you have placed some validation rules on your fields, check to see if you meet all of those rules first.
  • It's also possible that the changes you are trying to make in a particular record are having a conflict with a defined table relationship. If you defined a table relationship to your tables, you might want to try to change that relationship and see if it resolves the issue.

Whichever case you have, what you can do is add an error trapping code to your form (or modify your existing code if you have one) that will display a meaningful message to the user when the particular error is encountered.

Login/Register to Answer

Related Questions