How to bullet-proof mde?

[deko]

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.

[Salad]

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.

[deko]

> 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.

[Deano]

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.

[deko]

> 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!