login form

[koolguy]

hi,

im currently working on a db in ms-access. I have a table with the following columns: user_ID, name, password and group (admin/normal user).

i wish to create a login form such that when a normal user (where the user group = normal user ) he/she shall have access only to the forms in the datasheet mode. But when a admin logs in (where the user group = admin) he shall be able get access to the entire database (all tables/queries/forms/reports/modules..) in the design mode as well.

can anyone help me write a code for the above ?

 

[boblarson]

See if this sample from my website will give you a start:

http://downloads.btabdevelopment.com/samples/misc/LoginSample.zip

 

[koolguy]

thanx boblarson,

ur db was very helpful. I managed to mould ur code to fulfill my requirements and it works excellent. thankyou very much for your help !

 

[boblarson]