MSAccess Profile options

[dima69]

I'm looking for complete list of options that could be set using Access user profile. All I could found till now are some rather "harmless" options like TitleBar, Icon, StartupScreen and AppHelpFile. Also workgroup file reference and DBEngine settings could be overwritten. IS THAT ALL ? What about all the other settings, like "Behavior Entering Field", "Arrow Key Behavior" ect. ?

[ADezii]

@dima69
Just a little something to get you started. You will not be able to modify some Properties and Options, but you can experiment. The Database may also have to be Closed and Opened again before some take effect.

Dim prp As Property
Debug.Print "Properties for DBEngine"
Debug.Print "---------------------------------------"
For Each prp In Application.DBEngine.Properties
  Debug.Print "Name : " & prp.Name
  Debug.Print "Value: " & prp.Value
  Debug.Print "---------------------------------------"
Next
Debug.Print
Debug.Print
Debug.Print
Debug.Print "Properties for the Current Database"
Debug.Print "---------------------------------------"
For Each prp In CurrentDb.Properties
  Debug.Print "Name : " & prp.Name
  Debug.Print "Value: " & prp.Value
  Debug.Print "---------------------------------------"
Next
 

 
Properties for DBEngine
---------------------------------------
Name : Version
Value: 3.6
---------------------------------------
Name : LoginTimeout
Value: 20
---------------------------------------
Name : IniPath
Value: SOFTWARE\Microsoft\Office\9.0\Access\Jet\4.0
---------------------------------------
Name : DefaultUser
---------------------------------------
Name : DefaultPassword
---------------------------------------
Name : DefaultType
Value: 2
---------------------------------------
Name : SystemDB
Value: C:\PROGRA~1\MICROS~2\Office\SYSTEM.MDW
---------------------------------------
 
Properties for the Current Database
---------------------------------------
Name : Name
Value: C:\Dezii\Test.mdb
---------------------------------------
Name : Connect
Value: 
---------------------------------------
Name : Transactions
Value: True
---------------------------------------
Name : Updatable
Value: True
---------------------------------------
Name : CollatingOrder
Value: 1033
---------------------------------------
Name : QueryTimeout
Value: 60
---------------------------------------
Name : Version
Value: 4.0
---------------------------------------
Name : RecordsAffected
Value: 0
---------------------------------------
Name : ReplicaID
Value: 
---------------------------------------
Name : DesignMasterID
Value: 
---------------------------------------
Name : Connection
---------------------------------------
Name : AccessVersion
Value: 08.50
---------------------------------------
Name : Build
Value: 2719
---------------------------------------
Name : StartUpShowDBWindow
Value: True
---------------------------------------
Name : StartUpShowStatusBar
Value: True
---------------------------------------
Name : AllowShortcutMenus
Value: True
---------------------------------------
Name : AllowFullMenus
Value: True
---------------------------------------
Name : AllowBuiltInToolbars
Value: True
---------------------------------------
Name : AllowToolbarChanges
Value: True
---------------------------------------
Name : AllowBreakIntoCode
Value: True
---------------------------------------
Name : AllowSpecialKeys
Value: True
---------------------------------------
Name : StartUpMenuBar
Value: NorthwindCustomMenuBar
---------------------------------------
Name : Track Name AutoCorrect Info
Value: 1
---------------------------------------
Name : Perform Name AutoCorrect
Value: 1
---------------------------------------
Name : Auto Compact
Value: 0
---------------------------------------
Name : Log Name AutoCorrect Changes
Value: 0
---------------------------------------
Name : PagesFixed
Value: true
---------------------------------------
Name : Show Values Limit
Value: 1000
---------------------------------------
Name : Show Values in Indexed
Value: 1
---------------------------------------
Name : Show Values in Non-Indexed
Value: 1
---------------------------------------
Name : Show Values in Remote
Value: 0
---------------------------------------
Name : Show Values in Snapshot
Value: 1
---------------------------------------
Name : Show Values in Server
Value: 0
---------------------------------------
Name : HijriCalendar
Value: False
---------------------------------------
 

NOTE: Try the GetOption() Method in the Help Files, then follow the Link to Set Options from Visual Basic.

[dima69]

Thanks for your reply. The problems here are:
1. DEngine options can be set at runtime using DBengine.SetOption method, you don't need a user profile for that.
2. Application.SetOption method really takes care of the settings in question, but it affects ALL Access applications on the client computer, and this is what I'm trying to avoid.

[ADezii]

@dima69
Sorry for my misinterpretation. You are looking to set User specific Options, correct?

[dima69]

Yes, that's what I'm looking for - to set options so that this will affect my application only.

[puppydogbuddy]

Changes made with the SetOption method are only in effect for the current instance of the DBEngine object. For more information about the SetOption method, type SetOption method in the Office Assistant or on the Answer Wizard tab in the Help window, and then click Search.

See this link:Chapter 7: Optimizing Your Application

[dima69]

Yes, this is correct as applied to DBEngine options. But this is quite a different case with Application.SetOption method, as this method is actually changes registry settings for Access.

[puppydogbuddy]

Ok, if you don't want to use the DBEngine.SetOption method, you can use the profile method as discussed below, which was excerpted from the link I gave you in the previous post.

Excerpt:
If you want changes to Microsoft Jet settings to affect only your application or your session of Access, you can create a custom set of Registry subkeys, called a user profile, that contains settings to override default Registry settings. You use the /profile command-line option when starting Access to specify the user profile you want your application to use.

[dima69]

This is not that I don't want to use DBEngine.SetOption method (actually, I do use it), The issue is that I want to set an options other than DBEngine options, and I was wondering if this can be done by user profile.