Record Locking in Multi-User environment

[parry]

Hi, Ive looked through the Help in Acces but cant find an answer to this. Im aware that there are three options for record locking - No locks, all records and edited record. I want my database to have editing records option, but it appears that this option (tools-options-advanced tab) applies at the user level, so different users may have different record locking options when they open the database.

Is there an "On Open" type event that I can put in a module to set the record locking at database level? If so, what VBA method do i use - locking metho seems to apply to a recordset not the database.

cheers
Parry

_________________
cheers
Parry
This message was edited by parry on 2003-01-14 17:17

 

[Russell Hauf]

Hi Parry,

AFAIK, record-locking is usually handled via forms (at least that's how I do it). Do you have users that are accessing tables directly?

-Russell

 

[parry]

Hi thanks Russell. I didnt realise you could lock the records at form level. I will try that.