MS Access Properties

Question

Where can I find a native list of MS Access properties available through:

 CurrentDb.Properties("Property_Name_Here")

For example, I know;

• AppTitle is available to access the title of the application
• AppIcon is available to access the path of the icon used for the application

For different versions I am sure there are different properties. Are there lists by version? So for example, MS Access 2003 has these properties... while MS Access 2007 has these properties... and so on.

Answer 1

I don't believe there is a list anywhere. Tho, the Properties property is a collection. You can iterate over them and get all the ones associated. You'd have to do this all the versions of MS Access you're interested in. To further expound, almost all the internal objects, e.g. tables, fields, queries, etc. have properties. The field properties are particularly useful as you can assign how MS Access links and displays the field to the user.

Answer 2

There is a properties collection:

Sub ListProps()
    For i = 0 To CurrentDb.Properties.Count - 1
        Debug.Print CurrentDb.Properties(i).Name
    Next
End Sub