469,271 Members | 1,481 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

How to bullet-proof mde?

I've created an mde out of my mdb in and effort to prevent users from
changing settings/forms/etc. But I've discovered that the database window
is still available if I hold down the Shift key when opening the mde.

Forms can no longer be opened in Design View, which is good, but queries and
tables are still vulnerable. I've unchecked "Display Database Window" in
Tools >> Start Up, but that does not seem to help if the Shift key is held
down while starting up. Is there a way to permanently prevent the database
window from showing?

Other suggestions on making an mde bullet-proof?

Thanks in advance.
Nov 12 '05 #1
4 1562
deko wrote:
I've created an mde out of my mdb in and effort to prevent users from
changing settings/forms/etc. But I've discovered that the database window
is still available if I hold down the Shift key when opening the mde.

Forms can no longer be opened in Design View, which is good, but queries and
tables are still vulnerable. I've unchecked "Display Database Window" in
Tools >> Start Up, but that does not seem to help if the Shift key is held
down while starting up. Is there a way to permanently prevent the database
window from showing?

Other suggestions on making an mde bullet-proof?

Thanks in advance.

Make a copy of your database before trying this.

Click on Tools/Startup and click on Advanced. Remove checkbox on Use
Access Special Keys.

Nov 12 '05 #2
> Click on Tools/Startup and click on Advanced. Remove checkbox on Use
Access Special Keys.


I tried that - does not work. Holding the shift key still brought up the db
window on open -- but still, thanks for the suggestion.

The main problem is the ability to open queries and tables in design view,
as well as change things in Tools >> Options (I hide the command bar with
CommandBars("Menu Bar").Enabled = False in Form_Open on the main form).
Preventing the access to the db window would eliminate both vulnerabilities.
Nov 12 '05 #3
deko wrote:
Click on Tools/Startup and click on Advanced. Remove checkbox on Use
Access Special Keys.


I tried that - does not work. Holding the shift key still brought up
the db window on open -- but still, thanks for the suggestion.

The main problem is the ability to open queries and tables in design
view, as well as change things in Tools >> Options (I hide the
command bar with CommandBars("Menu Bar").Enabled = False in Form_Open
on the main form). Preventing the access to the db window would
eliminate both vulnerabilities.


The Access Security FAQ has the code you need to prevent the shift key
bypass.
Nov 12 '05 #4
> The Access Security FAQ has the code you need to prevent the shift key
bypass.


Great. Found the FAQ at
http://support.microsoft.com/default...ent/secfaq.asp

looks like what I need - thanks!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Gerald S. | last post: by
reply views Thread by Nikolaos Giannopoulos | last post: by
3 posts views Thread by Peter Schlenker | last post: by
1 post views Thread by David Bradbury | last post: by
8 posts views Thread by Udo Marx | last post: by
13 posts views Thread by Matt | last post: by
6 posts views Thread by Nathan Sokalski | last post: by
3 posts views Thread by vunet | last post: by
4 posts views Thread by asianmike | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.