Is it possible to restrict access to a page with the access level coming from a second table.
Let me explain what I would like to do
I have a (students) table with all then students personal details including username and password.
There is second table (enrolments) which is updated each time the student moves up a Module and the access level for each module is in this table.
I would like to restrict access to a page for each module.
Can anyone help please I am using MS access and ASP.
Thanks
Jacq

Hi Jacq,
how are you restricting access at the moment? You should be able to just join your two tables to get the access level. How do you have the enrolments table linked back to your students table?

Cheers

Seb