StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12394208
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-09-12T18:25:59.857
FavoriteCount
0
LastActivityDate
2012-09-12T18:33:51.800
LastEditDate
2012-09-12T18:33:51.800
LastEditorUserId
637931
OwnerUserId
637931
ParentId
11979648
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
You can list all of the properties for the database that exist at the time you run the code using a very simple procedure as seen here. <pre><code>Public Sub ListDBProps() Dim db As Database Dim prp As Property Set db = CurrentDb For Each prp In db.Properties Debug.Print prp.Name Next prp End Sub </code></pre> There are a couple of gotcha's in this. Notice I said "that exist at the time you run the code". That is, Access creates properties for the database (and presumably other objects as well) on an "as needed" basis. For instance, when you compile the database into, what used to be called an MDE, now an ACCDE, Access will add a new property of Type "Text" [10] named "MDE" with a value of "T". There are a couple of properties in the list you provided that fall into this category as well, such as "AllowBypassKey" and "AllowBreakIntoCode". Here is the list that I got when I ran this code on a simple database I opened up:     Name     Connect     Transactions     Updatable     CollatingOrder     QueryTimeout     Version     RecordsAffected     ReplicaID     DesignMasterID     Connection     ANSI Query Mode     Themed Form Controls     AccessVersion     NavPane Category     UseMDIMode     ShowDocumentTabs     Build     CheckTruncatedNumFields     ProjVer     StartUpShowDBWindow     StartUpShowStatusBar     AllowShortcutMenus     AllowFullMenus     AllowBuiltInToolbars     AllowToolbarChanges     AllowSpecialKeys     UseAppIconForFrmRpt     AllowDatasheetSchema     Show Values Limit     Show Values in Indexed     Show Values in Non-Indexed     Show Values in Remote     Auto Compact     DesignWithData     Picture Property Storage Format     NavPane Closed     NavPane Width     NavPane View By     NavPane Sort By     Track Name AutoCorrect Info     Perform Name AutoCorrect     HasOfflineLists You can add the Type property to your output easily enough. It is an integer value corresponding to the DataTypeEnum enumeration. The Value property of the Property can be a little more tricky. Usually it's a value that can be easily converted to a string value but there are a couple that cause a runtime error when you try to print them out or store them in a String variable. A little error handling in a small function can handle that with no trouble. My example was run on an ACCDB in Microsoft Access 2007. Enjoy . . . Doug
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhat are the Access startup properties that can be changed using VBA
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USdscarr
UserOwnerUserId
1. USdscarr
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.