Read Access Options (1 Viewer)

[gemma-the-husky]

I am trying to find a way to read access options settings.

For instance, I want to make sure that access is set to "shared access", and "No record locks", and maybe some other things.

I have been able to find the "record locking" by a bit of trial and error, but I can't find everything. Is anyone aware of a resource for this

eg this retrieves 0,1,2 depending on the selected locking behaviour.

Application.GetOption("Default Record Locking")

 

[gemma-the-husky]

I think I have found it now

https://docs.microsoft.com/en-us/office/vba/access/concepts/settings/set-options-from-visual-basic