Write Conflict (BIG PROBLEM)

[Kempes]

Howdy all,

Does anyone know the code for locking records when a user is editing.

Multi User environment, Records accessed via varying forms, but today this has corrupted one of the Main Table records showing a Jet engine error, another user is editing, but not allowing me to overwrite although no users are left in the db.

Also, will this need to be applied in the "on open" event of each form?

(Access 97).

Thanks
Kempes

 

[workmad3]

Go to the tools menu|options. On the advanced tab, change default locking to edited record. I set up a 2 - 3 user db using this and not had any trouble with record locks yet. If you need more than 4 people using it, I would suggest using something other than access.

 

[ghudson]

Your db must be split. The front end must be installed onto each of the users computers. Each front end must be linked to the one back end [shared tables on the network]. The workgroup .mdw file must also be installed onto each of the users computers. Keep everything in the same directory.