Disable design view

  • Thread starter Thread starter marilyn
  • Start date Start date
M

marilyn

I have created a password dialog box to log into my
database. When I right click on the dialog box I can
access the design view mode. How do I disable the design
view menu and the window unhide options.

I don't have time to play with ACCESS security so I
decided to design my own security levels. Do you think
this is wise.
 
To develop a home-made security system that was half as good as the built-in
one would probably take at least twice as long, so no, I don't think
deciding to go that route because of time pressures is a good idea.

That said, to answer your first question, look at the options in the Startup
dialog (choose 'Startup' from the 'Tools' menu) and also at some of the
properties on the 'Other' tab of the 'Properties' window in form design
view, e.g. 'Menu Bar', 'Tool Bar' and 'Shortcut Menu'.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Actually, to prevent users from seeing the access database window, and to
prevent them from entering design mode, you don't need any security at all.

The best solution is to create a mde file (you need to split your database
first to do this).

however, try downloading the 3rd example here:

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

In the above example, I hide all of the ms-access interface, and all I used
to do this was the tools->startup options.

So, give the above little application a try..and see how it "keeps" you out
of the ms-access stuff. After, you can take a look at the settings I used.
 
Back
Top