Knowledge.ToString()

List of MS Access Properties Available Through CurrentDB.Properties

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
AppIcon

I don’t know the data types of the these properties but I put it for quick reference.

Share

Comments

4 responses to “List of MS Access Properties Available Through CurrentDB.Properties”

  1. dmitry gorelenkov Avatar
    dmitry gorelenkov

    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

  2. Vlad Avatar
    Vlad

    Sub prtyEnum()
    Dim pr As Property
    For Each pr In CurrentDb.Properties
    Debug.Print pr.Name
    Next
    End Sub

  3. Dror Saddan Avatar
    Dror Saddan

    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

  4. Vishal Monpara’s Blog » Change MS Access application title and icon using VBA

    […] here for list of all properties exposed by CurrentDB.Properties(). Categories: MS Access Tags: application, icon, vba Comments (0) Trackbacks (0) Leave a […]

Leave a Reply

Your email address will not be published. Required fields are marked *