Disable Database Window

N

Nick

I would like to disable all access to the Database Window
without having to set up security levels or user groups.
Can this be done easily?

Any help appreciated.

Nick
 
A

Albert D. Kallal

Yes, you can use the settings in the tools->startup.

If you want to see an example of this, try downloading and running the 3rd
example here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

You will note that all of the ms-access interface is hidden. If you further
turned this into a mde, and disable the shift key..then you got something
quite well locked up. No security, or even any code is needed to accomplish
this...
 
N

Nick

The example you directed me to, is exactly what I am
trying to do. Is there a site I can investigate to achieve
this?

I have found shiftkey2000.zip to disable the shift key but
I still need to turned off the database window through the
startup, as you can still reactive the database window
even when the database is an MDE. Can you assist me with
how disable the startup?

Nick
 
A

Albert D. Kallal

The example you directed me to, is exactly what I am
trying to do. Is there a site I can investigate to achieve
this?

I have found shiftkey2000.zip to disable the shift key but
I still need to turned off the database window through the
startup, as you can still reactive the database window
even when the database is an MDE. Can you assist me with
how disable the startup?

Take a look at the settings in the tools->startup for my example that you
downloaded.

Note how hitting f11 does NOT show the database window

So, the trick here is two things:

in tools->startup you will notice how the

[ ] Use Access Special Keys

The above is un-checked..and that turns off things like hitting f11 to show
the database window.

The other thing here is you need to create a small tiny menu bar. It does
not have to be fancy..but just has a file->exit on it.

So, note again in the example of mine that I specified a menu bar for the
application, and this effectively hides all of the ms-access ones.

So, really, I only had to make a small custom menu..and then set the options
in the tools->startup. If you take that example of mine and convert it into
a mde..and disable the shift key...it is quite tight in terms of keeping
users out. It takes no code to do this...but just the right settings in the
tools-startup and a custom menu.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top