2007 StartUp Properties

[JDrown]

Back in the days of Access 2003 and before, Access supported the creation and
management of the following custom properties:

"StartupShowDBWindow"
"StartupShowStatusBar"
"AllowBuiltinToolbars"
"AllowFullMenus"
"AllowBreakIntoCode"
"AllowSpecialKeys"
"AllowBypassKey"

My question is, what are the Access 2007 equivalents to these? I've heard
that some have dropped off, a couple added, etc. etc. Yet I have not a found
a single place devoted to all of the Access 2007 programmable StartUp
properties. Can anyone help me with a resource which explains all of the
nuances of these properties for Access 2007?

 

[Allen Browne]

Access 2007 can work with mdb files in 2000, 2002/3 formats. It respects
those properties and behaves accordingly (e.g. hiding the NavPane of you
hide the DB window.)

There are some additional properties that did no apply in previous versions,
such as AllowDatasheetSchema. I don't have a complete list of them, but some
key ones are listed in this article:
Prevent Access 2007 users modifying existing databases
at:
http://allenbrowne.com/ser-69.html

If you want to examine the names of the properties for yourself, you can ask
it to list the properties of the db. Some properties don't exist until you
create them, so you might need to do this in a database where you can
actually set non-default values for the various properties so you can
actually see them.

The article above has a ShowProps() function that will enumerate the
properties of an object for you.