This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » ASP » Login and access level
Reply

Login and access level

Jacqui Brimacombe
Member



Since: 13 Feb 2010
Posts: 2
Posted 10 Jun 2010 01:26:09

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

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
Seb Adlington
Freaking Member



Since: 09 Aug 2001
Posts: 104
Replied 15 Jun 2010 23:19:04
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

Reply to this topic

Message
Reply
Follow us on Facebook Follow us on twitter Subscribe to the RSS feed
Activate your free membership today | Login | Currency