If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Limited Password
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! ---------- Rohn Everson |
#2
|
|||
|
|||
Limited Password
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? Thanks in advance for any direction you may be able to provide! ---------- Rohn Everson |
#4
|
|||
|
|||
Limited Password
Rohn wrote:
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.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. -- Joan Wild Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|