List of MS Access properties available through CurrentDB.Properties

By | December 15, 2009

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 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.

Vishal Monpara is a full stack Solution Developer/Architect with 12 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user’s mind leveraging geographically dispersed team members.

4 thoughts on “List of MS Access properties available through CurrentDB.Properties

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

  2. 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

  3. Vlad

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

Leave a Reply

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