Hi,
I have noticed that the protection on MS Access isn't really the best. I have been trying to figure out how to make a form that takes info from a table (columns: User name, Password)that a user can enter thier name and password, but I can't come up with any thing.
I would like to be able to enter any admin user name and password, and open the database with full permission. If an admin enters Name & password and the two fields match it opens the database windows. and if a regular non-input user enters their name, it opens up as pretty much as a read only. If after a non-input user enters their name and password and it matches it opens up the Main form.
Anyway of doing this?
I don't know if I explained it to good, so if you need more information, please ask.
I have noticed that the protection on MS Access isn't really the best. I have been trying to figure out how to make a form that takes info from a table (columns: User name, Password)that a user can enter thier name and password, but I can't come up with any thing.
I would like to be able to enter any admin user name and password, and open the database with full permission. If an admin enters Name & password and the two fields match it opens the database windows. and if a regular non-input user enters their name, it opens up as pretty much as a read only. If after a non-input user enters their name and password and it matches it opens up the Main form.
Anyway of doing this?
I don't know if I explained it to good, so if you need more information, please ask.