Application.SetOption 1

[OhioSteve]

I know that I can use Application.GetOption and Application.SetOption to change a specific environmental setting. Here is an example:

Application.SetOption ("Auto Compact"), 1

How to a get a list of EVERY option in Access 2003? If I did not that that line required the string "Auto Compact", what would I do?

 

[HarleyQuinn]

I Googled "2003 +SetOption +list" and got this link

http://msdn2.microsoft.com/en-us/library/aa172326(office.11).aspx

as a link from the first hit.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[OhioSteve]

Great find! I don't know how I missed that one.