Password for users

[smeco]

I have an access file, here at work, accessed by all the computers on the network, and I'd like to create passwords so that users can only access forms and reports which are relevant to them

how do i do this?

I've tried looking a the help file, but didn't get very far. Do I need to create the accounts on each computer or what?

thanks in advance
smeco

 

[smeco]

Does anybody know? Or perhaps I wasn't clear enough?

 

[Norie]

Perhaps you could take a seperate approach.

Create a database that only contains the data. Tben create 'front-ends' for users that only contain the forms and reports that they have access to.

Link the front-ends to the database containing the data an ddistribute the relevant front end to the relevant user.

 

[JWalcott]

If you go to Tools\Security Workgroup Administrator you can view the Microsoft Access Workgroup Information file that is currently being used. Copy this file and rename and then Join the Access Workgroup Information file through Tools\Security Workgroup Administrator. You can modify the security settings on your own machine using Tools\Security\ User and Group Accounts & User and Group Permissions.

This file can be placed on the network. You then have to get on each machine in the network and set the users up to open Access files using the Microsoft Access Workgroup Information file that you placed on the network. You do this by Joining the Access Workgroup Information file through Tools\Security Workgroup Administrator.

I definitely recommend copying the current Microsoft Access Workgroup Information file and modifying the copy. That way you always have the original security settings available.

J