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. ?
-
-
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.
Code: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
NOTE: Try the GetOption() Method in the Help Files, then follow the Link to Set Options from Visual Basic.Code: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 ---------------------------------------
-
Thanks for your reply. The problems here are:
1. DEngine options can be set at runtime using DBengine.SetOpt ion method, you don't need a user profile for that.
2. Application.Set Option 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.Comment
-
Yes, that's what I'm looking for - to set options so that this will affect my application only.Comment
-
SetOption method
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 ApplicationComment
-
Yes, this is correct as applied to DBEngine options. But this is quite a different case with Application.Set Option method, as this method is actually changes registry settings for Access.Comment
-
Ok, if you don't want to use the DBEngine.SetOpt ion 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.Comment
-
This is not that I don't want to use DBEngine.SetOpt ion 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.Comment
Comment