MDE File - Lock it (no table, shortcut keys, menus, navigation pane)

[mrbg07546]

Hi,

I have a mdb file i need to compile as a mde file.

However i also want to stop access to tables, and no menu bars(so it looks like a professional application).

any body have some code/process to do this cleanly

many thanks

 

[billmeye]

There are many properties that can be accessed to turn things off but there is only so much you can do.

      'PROGRAM STARTUP OPTIONS
                  Const DB_Boolean As Long = 1
80                ChangeProperty "StartupShowDBWindow", DB_Boolean, False
90                ChangeProperty "StartupShowStatusBar", DB_Boolean, False
100               ChangeProperty "AllowBuiltinToolbars", DB_Boolean, False
110               ChangeProperty "AllowFullMenus", DB_Boolean, False
120               ChangeProperty "AllowBreakIntoCode", DB_Boolean, False
130               ChangeProperty "AllowSpecialKeys", DB_Boolean, False
140               ChangeProperty "AllowBypassKey", DB_Boolean, False
150               ChangeProperty "AllowShortcutMenus", DB_Boolean, False
160               Application.SetOption "Show Hidden objects", False
170               Application.SetOption "Show System objects", False
180               Application.SetOption "enable mru file list", False
190               Application.SetOption "size of mru file list", False
200               Application.SetOption "Confirm Action Queries", False
210               Application.SetOption "Confirm Document Deletions", False
220               Application.SetOption "Confirm Record Changes", False

I don't have Access 2003 but I know there is a menu selection that allows you to change startup options by just unchecking a few boxes but what I showed you are basically the same as what is available.

 

[Alansidman]

In 2003, click on Tools, Startup and the attached window will open. Uncheck the boxes shown. Now, as the developer, if you need to access all that you have hidden, you will need to open the file by holding down the Shift Key and the Enter key contemporaneously.