Setting Access options (2000 – 2003)

Topic

New Reply

Is there anyway to check what options a user has set in their Access environment ?
– specifically what they’ve got “Default record locking” set to ?

Even better, is there someway to set it in VBA

Reply | Quote

Replies

Look up GetOption and SetOption in the online help for Access VBA. For a list of options, look up “Set Options from Visual Basic”.

Dim bytRecordLocking As Byte
bytRecordLocking = Application.GetOption(“Default record locking”)

Application.GetOption(“Default record locking”) = 2 ‘ Edited record

0 = no locking
1 = all records
2 = edited record

Reply | Quote

Look up GetOption and SetOption in the online help for Access VBA. For a list of options, look up “Set Options from Visual Basic”.

Dim bytRecordLocking As Byte
bytRecordLocking = Application.GetOption(“Default record locking”)

Application.GetOption(“Default record locking”) = 2 ‘ Edited record

0 = no locking
1 = all records
2 = edited record

Reply | Quote