Forums
This topic is locked
Login and access level
Posted 10 Jun 2010 01:26:09
1
has voted
10 Jun 2010 01:26:09 Jacqui Brimacombe posted:
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
Replies
Replied 15 Jun 2010 23:19:04
15 Jun 2010 23:19:04 Seb Adlington replied:
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
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