Setting Access options in code

[Rob]

Yes, I believe it is possible.

The way to turn of the confirmation for action queries in
code is to use:
SetOption "Confirm Action Queries", False

Many other options are available with SetOption as well.

Rob

 

[John Ford]

Thanks Rob, is there printed or online documentation for
setting these types of options?

 

[Allen Browne]

Try:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acglobaloptions.asp

For the names of the database properties:
Function ShowDbProps()
Dim db As DAO.Database
Dim prp As DAO.Property
Set db = DBEngine(0)(0)
For Each prp In db.Properties
Debug.Print prp.Name
Next
Set db = Nothing
End Function