Multi User/Access level password!

  • Thread starter Thread starter phenom5886
  • Start date Start date
P

phenom5886

Ive created a relatioal database for my A Level project and i want t
restrict what different users will be able to control once logged in t
the system! For navigation around the system i have created a custo
menu to replace the standard menu (file, tools etc)! Initially
thought i qould just hide the original menu and other things i didn
want them to see via the start-up options but when i did this i coul
not find a way to restore the original menu thus i decided this was no
feasable as upgrades maybe required in the future and i would have t
be able to access these features! Thus i decided a multi user leve
password system would be my only option but i have no idea how t
create such a thing! SO if neone has ne help on this subject or know
of an easier way i could achieve my goal then help would be muc
appreciated!

Tnku very much
 
To implement Access security, check out the Access Security FAQ:
http://support.microsoft.com/support/access/content/secfaq.asp

Make sure you read it thoroughly several times before trying to apply
security, don't skip any steps, and use a backup copy of your database.

Regarding your comment about not being able to find a way to restore the
original menu, try holding down the shift key while you're opening the
database. Unless you've added and set the AllowBypassKey property, that
should do it.
 
Regarding your comment about not being
able to find a way to restore the original
menu, try holding down the shift key while
you're opening the database. Unless you've
added and set the AllowBypassKey
property, that should do it.
Click to expand...

Two alternatives that you can use and still use AllowBypassKey on the
production version:

(1) Maintain a separate copy for ongoing development, and only do the final
polishing, including the AllowBypassKey, on each production version as you
release it. Maintaining a separate development copy is a really good idea in
any case, even if security isn't an issue.

(2) Just in case... code yourself in a "back door", hidden way to enter and
remove the bypass key block and to unhide the database window.

Larry Linson
Microsoft Access MVP
 
Back
Top