• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • 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 Access MVP)Database ArchitectCommented:
" 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 Access MVP)Database ArchitectCommented:
Note ... once you can get back in, you can change the other properties as necessary.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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