Test for the values of the database properties

Is there any way I can set or test for the values of the database properties for:
Confirm Record Changes
Confirm Document Deletions
Confirm Action Queries

Thanks in advance.
Clive BeatonAccess DeveloperAsked:
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
This will return the value:

application.GetOption("Confirm Record Changes")

This will set the options:

   Application.SetOption "Confirm Action Queries", 1
    Application.SetOption "Confirm Document Deletions", 1
    Application.SetOption "Confirm Record Changes", 1
Clive BeatonAccess DeveloperAuthor Commented:
Thanks, Joe.  Just what I needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.