You and Another User are attemping to change the database

[TheFitz]

ACCESS 97, in case it makes a difference

All,

I have got a really strange error on the system. The user goes into the system, does an update, comes out and then tried to go back in and they ge the error:

Microsoft Jet Database engine stopped the process because you and another user are attemping to change the same data at the same time.

This is quite an impressive error as there is only one use on the system. I have completely rewritten the code that does this and it still happens.

I have tried using both a docmd.runsql with an SQL update statement and using a record set and a do loop. Both produce the error.

Thankfs for your time in advance,



Fitz

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[tonyflavell]

Hi there

This happens when you make changes to a table through a form without specifically saving the amended recordset and move on to changing something else. It can usually be prevented by the judicious use of "Me.Requery" in various places!

Just an idea

Regards

Tony

 

[Rauken]

Yes .Requery is the solution. Had the same problem when doing DoCmd.RunSql statements and then tried to move to another record.