Help Please Access 2003

[jmc]

I am setting up a new database at work and I am having troubles with the security. It is a simple database with 1 table, form and report. I have set up user names and passwords to get in. Is there any way I can set the security so each person that logs in only has access to certain records in the table. For example the supervisor of shipping logs in I only want him to see the records from shippping not any other departmants. Please help if you can. [e-mail]

[PianoMan64]

Since you've setup all the accounts and passwords so that you can log into access, then all you need to do is to place restrictions on the user data based on the username. This is done by creating a table that would house all the usernames and the respective departments that this particular user belongs too.

then you would use the function CurrentUser() to see who the current user is and then you can determine what department they are in and so on.

If you need details has to how to do this, please let me know, I can include code examples.

Hope that helps,

Joe P.