Can't update database [RESOLVED]

[Supremus]

I have 5 networked computers. Eack one runs a separate version of my program with one central database.

I occasionally have a problem with the database and receive an error messsage saying "Can't update. Database is locked". (or something similar).

This happens on the .Update command. All recordsets use "adlockOptimistic". How important is the .update command??

[si_the_geek]

The .Update command is what actually writes the data to the database. The alternative is to .CancelUpdate

That error generally means that you are leaving records in "edit" mode (from the point you set a value to the point you .Update) for too long - so other users cannot read the same records.

As a general rule, you should make the actual time in edit mode as small as possible, preferably with the whole process being in a few lines of code without any breaks/pauses (so no MsgBox'es etc).

[Supremus]

Thanks Si. My code is messy, so I'll tidy it up.