Changing a record in a table

[bri822]

Right now I have two forms. One if a job information form that is really a continous subform on the main form, and I also have a seperate work order form. One the job form, there is a button to click to bring up the work order form. Also on the job form, there is a check box that is checked if the job contains a work order ( went to work order form and saved it). The check box is bound to a yes/no field on a table

I have not been able to check that box. If I try to check just the box after saving, when you do try to save the form it says that "another user has edited your information" and prompts you on what you want to do. I can not have that message up. So I am thinking I have to go through and edit the record. I was wondering if anyone could help me out on ideas to edit the record. I am using Access 2000. Any help would be greatly appreciated, thank you.

Brian

 

[cogent1]

This is a message that is caused in multi-user environments when two users change a record at the same time and no record-locking is enforced. It can also occur when two local copies of the db are open. Is yours a multiuser app.?

 

[bri822]

I thought it would normally be a multi user issue. The only copy of the program is on my local computer. I am sure that no one else is using it or is logged in since no one else has a copy. I figured that it considered "someone else changing data" when I checked the check box after returning to the form. It comes up with the error when you try to save the record again just after I checked the box. Thanks for the idea, but I am certain it is not that.

Brian

 

[cogent1]

Then it can only be for two other reasons:

1) You have the same RECORD open in separate forms /queries simultaneously at some point in your procedure. It doesn't have to be the same FIELD involved. If you set pessimistic locking, the system should prevent this from happening.

2) The database is corrupted.


I suspect 1), so try changing the locking method first

 

[bri822]

Thank you for explaining the error. I know that it definitely fits under the first one. I do have the record open in another form at the same time I am trying to update it. That makes sense. I guess I was thinking I could update the record and then maybe update the form. I guess my new problem would be what do I do inorder to take care of that. I do need to display the record when the person is done with the other form. If I close it, I would have to open it in another form b/c the form can only add records, not edit them. I am open to suggestions. I would appreciate any help anyone would be able to give. Thanks,

Brian

 

[cogent1]

You can write an error handling routine that specifically deals with this error by ignoring it. Look up acDataErrorContinue in Help.

 

[Steven Deetz]

I too have had similar error messages like Brian describes. I will pay closer attention next time the error occurs because I swear that only one form is open and only one person is using the application. I had always dismissed it to be a bug, and if it became an annoying bug, compact-and-repair to the rescue!