HI All,
I've searched for a solution to this question but most of the suggestions i've come across are too complicated for me to follow. I have a database which is finished and working fine but what i need to add is a Log In form which gives a user either full access or just read only access to the database. I want to create a table (tblUsers) with the fields
UserName
Password
AccessType (Full or Reader)
I need to either let the user (Full) have full access to everything, or the user (Reader) have access to the various forms but just be able to read/print off reports etc. Would i need some code for the OnLoad event of the forms ?. I'd appreciate any help at all
Thanks, Em
I've searched for a solution to this question but most of the suggestions i've come across are too complicated for me to follow. I have a database which is finished and working fine but what i need to add is a Log In form which gives a user either full access or just read only access to the database. I want to create a table (tblUsers) with the fields
UserName
Password
AccessType (Full or Reader)
I need to either let the user (Full) have full access to everything, or the user (Reader) have access to the various forms but just be able to read/print off reports etc. Would i need some code for the OnLoad event of the forms ?. I'd appreciate any help at all
Thanks, Em