Limited Password


R

Rohn

We don't necessarily need security for this database..... The database is set to open up to the Switchboard and limited menus and the database itself is hidden, which is just great, no problems.

We would like to make it so that if another user, wanted to open the database with the Shift key pressed, then they would get a password prompt.... so something like this? Is it possible to only password the edit and development portion and not force users to enter passwords?

Thanks in advance for any direction you may be able to provide!
 
Ad

Advertisements

J

Jim/Chris

Have you thoght of disabling the shift bypass key or of
making you MDB a MDE?

Jim
-----Original Message-----
We don't necessarily need security for this database.....
The database is set to open up to the Switchboard and
limited menus and the database itself is hidden, which is
just great, no problems.
We would like to make it so that if another user, wanted
to open the database with the Shift key pressed, then they
would get a password prompt.... so something like this?
Is it possible to only password the edit and development
portion and not force users to enter passwords?
 
R

Rohn

Thank you for the advice... how do I disable the bypass? And if I did bypass it, how would I get into the database to continue updates and do the occasional modifications that are needed?

Also, after reading about MDE, I am not sure I want to do that either! at least not at this point.
_____
Rohn Everson
(712) 548-6900 (cell)
UOP email: (e-mail address removed)
Yahoo messenger: (e-mail address removed)
 
Ad

Advertisements

J

Joan Wild

Rohn said:
Thank you for the advice... how do I disable the bypass?
There is code at

http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm
you can use to disable the shiftkey.

You can modify the code to set it back from another database.

Or you could use Albert's utility to set it on/off. Look for By Pass Shift
Key Code at
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
Also, after reading about MDE, I am not sure I want to do that
either! at least not at this point.
Why not? You just need to be sure to keep a copy of the mdb, as that's the
only place you can make design changes to forms/reports.
 

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

Similar Threads


Top