Security Questions

[HHUK]

Hey everyone,

I've been working on a database for a while now and I believe the outline of it is complete, all that's left is the data inputting and security.

I tried to make my own security based around usernames and passwords but I was hopeless at applying MD5 encryption on the password field and working with the permissions afterwords.

I went through the user level security wizard and I set up the accounts and there's permissions to read tables, etc.. but there's no good tutorials or help files to do anything more complicated and I wouldn't know how to without reference materials.

Now.. the thing I wish to do is limit users by record, each record has a "worker" assigned to it. I want the user to log on, open the main menu form, open the client's form, then only that worker's clients would be available to go through with the forwards and back arrows, or the drop down list would be filtered.

Is this too complex to do with the user level security built into access?

Are there any alternate methods of doing so?

I can upload my database if anybody wants a better look.

- Luke.

 

[Dennisk]

you can test who logs by using the CurrentUser() Function. Then you can replace each form's recordset with a query, that filters the records for the loggoen user.

 

[HHUK]

you can test who logs by using the CurrentUser() Function. Then you can replace each form's recordset with a query, that filters the records for the loggoen user.

Thanks mate, perfect. That function solved it all.

The CurrentUser slotted into some VBA code that wasn't working that well and now it all works great.