Microsoft Access 2010 Complete List of Builtin Database Properties

Does anyone know of a complete list of the Builtin Database Properties for Access 2010?

I can list the few properties that my database has (with lots of trouble), but I would like to know all of the builtin properties so that I can set them if possible.

Has MS ever disclosed why they make this list so hard to acquire?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
what kind of Listing built-in Access database properties are you referring to?

generally as a start, in VBA editor, you can go to Object Browser (press F2) to get a list of methods and properties of the relevant access objects available.

and then you can refer to MSDN to see if there are more relevant info which can enlighten you to the information you needed.

Get help for built-in functions, properties, macro actions, and SQL keywords

Articles using DAO to get the database properties:
Listing built-in Access database properties

MS Access Databases – Properties: How To Set It Using Access VBA And The DAO Object
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The code at the link one of ryan's links above will error out:

Not all properties have all attributes, so you must either (a) enable error checking or (b) modify the code to skip over those attributes that have no value.

Just one more reason to NOT use links for answers, in my opinion. Instead, write your own routine and post it here.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Helen FeddemaCommented:
Try this code; it lists both built-in and custom database properties for the current database:

Public Function ListCustomProps()
'Created by Helen Feddema 2-Sep-2006
'Modified by Helen Feddema 6-Sep-2006

   Set dbs = CurrentDb
   Debug.Print "User-defined properties in database:"
      For Each prp In dbs.Properties
         On Error Resume Next
         Debug.Print vbTab & prp.Name & ": " & prp.Value
      Next prp

End Function

Open in new window

10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

koughdurAuthor Commented:

I tried that.  It seemed to only want to list properties that I had explicitly assigned and not default properties.  I want to see all properties so that I can change some if I need to.

Also, when I tried to print out prp.Value, for some properties it gave me an error saying that that operation was not valid for that object.
koughdurAuthor Commented:

Thanks very much for your thorough response.

1) Object Browser.  There is no way to view the DB properties in the Object Browser.  All you get is the method 'Properties'.  There is no list of valid value for properties.

2) This page suggests I need to right-click on an object to get its list of properties.  I have used that numerous times to get/set properties for forms, reports, tables, queries, etc.  However, there is no way I know of to right-click on the database itself.

3) I saw this code and tried to use it.  It seemed to only want to list properties that had been explicitly set.  Also it gave me an error for some properties when I tried to print out the Value.

4) I have used code like this to get/set properties that I know about.  However, there is no way that I can see to use this code to discover properties I haven't heard about through the grapevine.

If you know of a way I can right-click on the database to get a list of properties that would be great.
koughdurAuthor Commented:

Thanks for confirming what I experienced.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>However, there is no way I know of to right-click on the database itself.
what kind of Access database properties are you trying to retrieve or set via VBA ?
Helen FeddemaCommented:
My procedure was originally created to list custom database properties, but when I ran it, I noticed that it also listed (at least some) of the built-in properties.  I don't know of any way to get all of the built-in properties, unfortunately.  Here is what I get when I run the procedure:

Database properties:
   Name: \\OPTIPLEX-WORK\Users\Helen Feddema\Documents\Writing\WAW\Ebooks\Working with Word\4th Edition Material\Office 2010 Files\Working with Word 2010.accdb
   Transactions: True
   Updatable: True
   CollatingOrder: 1033
   QueryTimeout: 60
   Version: 14.0
   RecordsAffected: 0
   ANSI Query Mode: 0
   Themed Form Controls: 1
   Use Microsoft Access 2007 compatible cache: 0
   Clear Cache on Close: 0
   Never Cache: 0
   AccessVersion: 09.50
   NavPane Category: 0
   Show Navigation Pane Search Bar: 1
   UseMDIMode: 1
   ShowDocumentTabs: True
   Picture Property Storage Format: 0
   WebDesignMode: 0
   CheckTruncatedNumFields: 1
   Theme Resource Name: Office Theme
   AppTitle: Working with Word 2010 (4th edition)
   StartUpShowDBWindow: False
   StartUpShowStatusBar: True
   AllowShortcutMenus: True
   AllowFullMenus: True
   AllowBuiltInToolbars: True
   AllowToolbarChanges: True
   AllowSpecialKeys: True
   UseAppIconForFrmRpt: False
   AllowDatasheetSchema: True
   DesignWithData: True
   Show Values Limit: 1000
   Show Values in Indexed: 1
   Show Values in Non-Indexed: 1
   Show Values in Remote: 0
   Auto Compact: 0
   Track Name AutoCorrect Info: 0
   HasOfflineLists: 70
   NavPane Closed: 0
   NavPane Width: 227
   NavPane View By: 0
   NavPane Sort By: 0
   ProjVer: 119
   FrontEndSaveNo: 2
   FrontEndSaveDate: 6/13/2015
   LastMeetingDate: 12:00:00 AM
   ExclusionChoice: 3
   BackupSuffix: _copy
   BackupChoice: 2
   BackupPrefix: _
   PrefixOrSuffix: 2
   DateFormat: d-mmm-yyyy
   OrderID: 11077
   StartUpForm: fmnuMain
   TOCPages: 3
   StartDate: 12:00:00 AM
   EndDate: 12:00:00 AM
   CustomerID: FOLIG
   SaveDateFormat: d-m-yyyy
koughdurAuthor Commented:

The properties I am trying to list are what are in Helen's last response.


When I added the error trapping suggested by Scott I got a list similar to yours.  Depending on the database I ran it on I got different numbers of properties.  So it seems that it mostly just shows properties that have been set to a specific value either by the user or by default.  It also seems to know about some properties that don't have values (i.e. the one's that error out when I tried to print their values) so there doesn't seem to be any consistency in what is shown.

I notice your list doesn't include AllowBypassKey.  This is one of the properties that will only show up if you explicitly set it.  I'm guessing that there are some other hidden properties that I could take advantage of if only I knew of their existence.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.