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

How to bullet-proof mde?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
> 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

P: n/a
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

P: n/a
> 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.