P
PPV
In My Media database, main menu->tools/Options/Advance,
1. Default_record_locking is set for No_Locks, this
means by default all form and query objects has
Record_Locks property as No_Locks. It included
the select complex queries having more than 8/10
inner joins, which are attached to forms.
Guessing, it does not prevent two or more users editing
data at the same time might be leading to database locking
and increases the possibilities of my database crash and
every time I need to repair the database.
Note that Default_Open_Mode is set for Shared and
all action queries(Append, Delete, Update) has
Record_Locks property as Edited_Record
To solve this problem, do I need to change the select
queries record_locks property to Edited_Record? If I do
this, how it will behave in multiple user environment?
Will it lock the master data which is part of inners joins
of select queries?... Will it solve the my problem?
Regards,
PPV
1. Default_record_locking is set for No_Locks, this
means by default all form and query objects has
Record_Locks property as No_Locks. It included
the select complex queries having more than 8/10
inner joins, which are attached to forms.
Guessing, it does not prevent two or more users editing
data at the same time might be leading to database locking
and increases the possibilities of my database crash and
every time I need to repair the database.
Note that Default_Open_Mode is set for Shared and
all action queries(Append, Delete, Update) has
Record_Locks property as Edited_Record
To solve this problem, do I need to change the select
queries record_locks property to Edited_Record? If I do
this, how it will behave in multiple user environment?
Will it lock the master data which is part of inners joins
of select queries?... Will it solve the my problem?
Regards,
PPV