CurrentDB.Properties is nothing but a collection. If you can iterate through a collection, you will be able to get the list of all the properties. Code to iterate through all properties is
Dim i As Integer For i = 0 To CurrentDb.Properties.count - 1 Debug.Print CurrentDb.Properties(i).Name Next
It gave me the following list of properties.
Name
Connect
Transactions
Updatable
CollatingOrder
QueryTimeout
Version
RecordsAffected
ReplicaID
DesignMasterID
Connection
ANSI Query Mode
Themed Form Controls
AccessVersion
Build
ProjVer
StartUpForm
StartUpShowDBWindow
StartUpShowStatusBar
AllowShortcutMenus
AllowFullMenus
AllowBuiltInToolbars
AllowToolbarChanges
AllowSpecialKeys
UseAppIconForFrmRpt
Track Name AutoCorrect Info
Perform Name AutoCorrect
AppTitle
AppIconI don’t know the data types of the these properties but I put it for quick reference.
so you can get types too
Sub testCodeDBProperties()
On Error Resume Next
Dim prop As Variant
For Each prop In CodeDb.Properties
Debug.Print prop.name & “: ” & prop & ” type: ” & VarType(prop)
Next prop
End Sub
type names: http://www.java2s.com/Code/VBA-Excel-Access-Word/Data-Type/ValuesreturnedbytheVarTypefunction.htm
Sub prtyEnum()
Dim pr As Property
For Each pr In CurrentDb.Properties
Debug.Print pr.Name
Next
End Sub
I think that there are other Properties which were not enumerated. For example:
Auto Compact – boolean. Perform compact when the database is closed.
AllowBypassKey – boolean. Allow you to stop the AutoStar macro with Shift when starting the database.
Dror