admin login on access??

[rthakral]

Hi, good morning!



I was wondering if it's possible and how to do it if it is, to create an admin login on access. So for users who are allowed to edit can login with their username and pw can do so and for those who don't have a proper username and pw can click cancel and view the database as a 'read-only'

Is this possible? If so, how would one go about doing this? I'm having trouble attaching my DB to the forum because I can't make it a zip file, our work computers has everything like that disabled, and I can't download anything to zip it either since those are all disabled as well.

Please advise! Any help would be greatly appreciated! Thank you!

[rthakral]

anybody know if this is possible? admin login of sorts?

[June7]

This certainly requires VBA coding.

You can hard code a password or have a table of users with defined privileges and open forms accordingly.

Username/password is common topic in forum. A search should return many threads with more info.

Be aware that holding down the shift key when opening mdb or accdb file will override automatic code execution and most project settings and then user can do what they want with db.