Access 2003 Add/Update protocol

Question

I have used an access database that someone else created.  I have a screen w/ comment fields that in the past I have just clicked on, typed in and closed the screen and changes were saved.  Today, I wrote more than usual and when it was time to switch to another comment field on the same screen, the message "Update or CancelUpdate without AddNew or Edit" appeared.  I cannot click on anywhere else or close the screen without the message coming up that new data entered will be lost.

Why did this occur?  Should I use the edit button before entering data?  Having never been trained in this software I am not sure of protocol.

 

Answer 1

Hi Connie-st,

Are you the only one who uses this database? If others use the database, are they also seeing the error?

It sounds like there was either a code change made or possibly corruption. Are you familiar with doing any design work in Access? If not, is the creator of the database available to look into the issue?

Do you have access to a backup copy of the database?

Best Regards,

Kathy
Microsoft Online Community Support

 

 

Answer 2

As an end-user there is no way you can fix this problem. You need the original developer or other competent assistance.

Technically speaking the error means that there is code that updates a recordset, and because of some erroneous flow it is trying to update a record without first putting that record in edit mode. A good developer should have no problem fixing this.

If you have an Edit button on your form, then yes I would think this could put the record in edit mode so I would certainly try that ON A COPY OF YOUR DATABASE.

 

---

-Tom. Microsoft Access MVP