• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

set db.Properties in ms access

Hi Expert,

I used the following code for testing and learning purpose in my VBA code.
      Set dbs = DBEngine(0)(0)
      dbs.Properties("StartupShowDBWindow") = False
      dbs.Properties("StartupShowStatusBar") = False
      dbs.Properties("AllowBuiltinToolbars") = False
      dbs.Properties("AllowFullMenus") = False
      dbs.Properties("AllowBreakIntoCode") = False
      dbs.Properties("AllowSpecialKeys") = False
      dbs.Properties("AllowBypassKey") = False

Now I can not even view my code? Waht I did wrong and what I can do next to be able to see my code and change it?

Thanks in advance.

  • 2
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
" Waht I did wrong"

For starters ... this:

 dbs.Properties("AllowBypassKey") = False

See this link:


Scroll down to ' Pass Shift Key Code'

You can use this code to browse to your mdb ... and re enable the Shift Key Bypass.

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Note ... once you can get back in, you can change the other properties as necessary.


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now