Locked form (1 Viewer)

[adi32]

i have an access database in lan and when 2 users are working in the same form and in different record the record will be locked
ex if the first user is changing the date in the fist record the second user cant change another record
http://briefcase.pathfinder.gr/download/adi32/2976/399219/0/test.zip
to check open together the forms table1 table1b and try to change two different records
thank you

 

[MStef]

Hello adi32!
Open your form in design view,
check Properties "RECORD LOCKS",
I think it is "All Records".

 

[adi32]

no it is not

 

[MStef]

If it is not, check this;
Tools, Options, Advanced,
"Default open mode"
"Default record locking".