Write conflict error?

[Rixx]

Hi all,

I have followed the advice on this page of 'how to update stock levels automatically' in access.

http://support.microsoft.com/default.aspx?scid=kb;en-us;252813

I implemented this in the Northwind database and everything was fine. I implemented this in my database (which is very similar to the northwind in structure!) and receive this error:

"WRITE CONFLICT
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered and then paste your changes back in if you decide to make changes."

I have no idea how this is happening. Can anyone throw some light on this? Any advice will be greatly appreciated.

Regards

 

[Pat Hartman]

Please don't send requests to me (or any other member) for private consulting services. Just post your questions here.

You added additional detail in the question directed to me which indicated that you were saving the current record. The problem is that you are already in the process of saving the current record when you reach the form's BeforeUpdate event so you can't issue a save recommand from within that sub. Doing so would cause a never ending loop. The first thing that happens when you tell Access to save the current record is that it runs the form's BeforeUpdate event which you are already in! Access is smart enough to recognize that and throw an error message. The "other user" is YOU.

If you want us to sort it out, you'll need to post all the code behind the form.

 

[Rixx]

Hi mate,

I apologise for 'asking for your help' via pm. I did not realise that it would become an inconveniance or offend.

As it can be seen I am in need of help concerning this database as I have not been learning access for that long. I have uploaded the database and it can be found here:

http://rixx.sytes.net/sdp2005.zip

I am particularly having errors as described, and also when I open the Order Form and jump to the subform entry for item and then choose an item. An error should come up exclaiming that "Customer" is required first.

However that is giving me a lot of grief also!

In anycase, please help if you can.

Thank you.