Individual Page Security

[Specific User Form Access]

I have an access DB with approx 400 personnel records contain sensitive
personal information. I would like for individuals to be able to change SOME
of their data. I am not sure how to secure the individual pages so that they
can only see their particular page and no one elses..... Suggestions???

 

[Joan Wild]

Although you can restrict users to information via queries and you could use Access security to limit their access to the information, I don't think you should be using Access if you want to protect 'sensitive personal information for 400 personnel'.

It doesn't take that much to break through the Access barriers that you set up.

You should be using a server database (SQL Server) for the backend. Note that Access could still be used for the frontend to this.