By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

MSAccess Profile options

dima69
Expert 100+
P: 181
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. ?
Jan 15 '09 #1
Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,623
@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.
Expand|Select|Wrap|Line Numbers
  1. Dim prp As Property
  2. Debug.Print "Properties for DBEngine"
  3. Debug.Print "---------------------------------------"
  4. For Each prp In Application.DBEngine.Properties
  5.   Debug.Print "Name : " & prp.Name
  6.   Debug.Print "Value: " & prp.Value
  7.   Debug.Print "---------------------------------------"
  8. Next
  9. Debug.Print
  10. Debug.Print
  11. Debug.Print
  12. Debug.Print "Properties for the Current Database"
  13. Debug.Print "---------------------------------------"
  14. For Each prp In CurrentDb.Properties
  15.   Debug.Print "Name : " & prp.Name
  16.   Debug.Print "Value: " & prp.Value
  17.   Debug.Print "---------------------------------------"
  18. Next
  19.  
Expand|Select|Wrap|Line Numbers
  1.  
  2. Properties for DBEngine
  3. ---------------------------------------
  4. Name : Version
  5. Value: 3.6
  6. ---------------------------------------
  7. Name : LoginTimeout
  8. Value: 20
  9. ---------------------------------------
  10. Name : IniPath
  11. Value: SOFTWARE\Microsoft\Office\9.0\Access\Jet\4.0
  12. ---------------------------------------
  13. Name : DefaultUser
  14. ---------------------------------------
  15. Name : DefaultPassword
  16. ---------------------------------------
  17. Name : DefaultType
  18. Value: 2
  19. ---------------------------------------
  20. Name : SystemDB
  21. Value: C:\PROGRA~1\MICROS~2\Office\SYSTEM.MDW
  22. ---------------------------------------
  23.  
  24. Properties for the Current Database
  25. ---------------------------------------
  26. Name : Name
  27. Value: C:\Dezii\Test.mdb
  28. ---------------------------------------
  29. Name : Connect
  30. Value: 
  31. ---------------------------------------
  32. Name : Transactions
  33. Value: True
  34. ---------------------------------------
  35. Name : Updatable
  36. Value: True
  37. ---------------------------------------
  38. Name : CollatingOrder
  39. Value: 1033
  40. ---------------------------------------
  41. Name : QueryTimeout
  42. Value: 60
  43. ---------------------------------------
  44. Name : Version
  45. Value: 4.0
  46. ---------------------------------------
  47. Name : RecordsAffected
  48. Value: 0
  49. ---------------------------------------
  50. Name : ReplicaID
  51. Value: 
  52. ---------------------------------------
  53. Name : DesignMasterID
  54. Value: 
  55. ---------------------------------------
  56. Name : Connection
  57. ---------------------------------------
  58. Name : AccessVersion
  59. Value: 08.50
  60. ---------------------------------------
  61. Name : Build
  62. Value: 2719
  63. ---------------------------------------
  64. Name : StartUpShowDBWindow
  65. Value: True
  66. ---------------------------------------
  67. Name : StartUpShowStatusBar
  68. Value: True
  69. ---------------------------------------
  70. Name : AllowShortcutMenus
  71. Value: True
  72. ---------------------------------------
  73. Name : AllowFullMenus
  74. Value: True
  75. ---------------------------------------
  76. Name : AllowBuiltInToolbars
  77. Value: True
  78. ---------------------------------------
  79. Name : AllowToolbarChanges
  80. Value: True
  81. ---------------------------------------
  82. Name : AllowBreakIntoCode
  83. Value: True
  84. ---------------------------------------
  85. Name : AllowSpecialKeys
  86. Value: True
  87. ---------------------------------------
  88. Name : StartUpMenuBar
  89. Value: NorthwindCustomMenuBar
  90. ---------------------------------------
  91. Name : Track Name AutoCorrect Info
  92. Value: 1
  93. ---------------------------------------
  94. Name : Perform Name AutoCorrect
  95. Value: 1
  96. ---------------------------------------
  97. Name : Auto Compact
  98. Value: 0
  99. ---------------------------------------
  100. Name : Log Name AutoCorrect Changes
  101. Value: 0
  102. ---------------------------------------
  103. Name : PagesFixed
  104. Value: true
  105. ---------------------------------------
  106. Name : Show Values Limit
  107. Value: 1000
  108. ---------------------------------------
  109. Name : Show Values in Indexed
  110. Value: 1
  111. ---------------------------------------
  112. Name : Show Values in Non-Indexed
  113. Value: 1
  114. ---------------------------------------
  115. Name : Show Values in Remote
  116. Value: 0
  117. ---------------------------------------
  118. Name : Show Values in Snapshot
  119. Value: 1
  120. ---------------------------------------
  121. Name : Show Values in Server
  122. Value: 0
  123. ---------------------------------------
  124. Name : HijriCalendar
  125. Value: False
  126. ---------------------------------------
  127.  
NOTE: Try the GetOption() Method in the Help Files, then follow the Link to Set Options from Visual Basic.
Jan 16 '09 #2

dima69
Expert 100+
P: 181
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.
Jan 16 '09 #3

ADezii
Expert 5K+
P: 8,623
@dima69
Sorry for my misinterpretation. You are looking to set User specific Options, correct?
Jan 16 '09 #4

dima69
Expert 100+
P: 181
Yes, that's what I'm looking for - to set options so that this will affect my application only.
Jan 16 '09 #5

puppydogbuddy
Expert 100+
P: 1,923
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
Jan 19 '09 #6

dima69
Expert 100+
P: 181
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.
Jan 19 '09 #7

puppydogbuddy
Expert 100+
P: 1,923
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.
Jan 20 '09 #8

dima69
Expert 100+
P: 181
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.
Jan 20 '09 #9

Post your reply

Sign in to post your reply or Sign up for a free account.