Password Access

Hi,
here is what you can do:

1. Use Advanced Security option in ASPRunner.
   
2. Use first option (Users can and edit other users data)
   
3. Add Admin user
   
4. Build ASP pages
   
5. Open ..._list.asp file in text editor and scroll down to find CheckSecurity function at the very end. Add the following section in the begining of this function:
   

   if Session("AccessLevel")=ACCESS_LEVEL_ADMIN then
   

   
     CheckSecurity = True
   
     Exit Function
   
   else
   
     CheckSecurity = False
   
     Exit Function
   
   end if

I hope this helps.

Perfect , exactly what i need <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=1069&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Thanks for the great support !!
Steve

I think my query is similiar but I have one caveat. I just purchased this for our company and the COO was impressed. However now he wants me to create authentication based on a filter. Say East Coast Sales Managers can only view East Coast Sales records. West Coast Sales Managers can only view West Coast Sales Records. We have one column which contains the region of coverage. Of course this column contains all sales regions. The boss does not want people from the East coast viewing the West coast records. Is there a way to filter the records in this column to only display records for a particular sales manager based on login name. I only have 6 users currently accessing the database.

Hi,
I would recommend to use Advanced security settings -> Users can view and edit their own data only in ASPRunner.
Also you will need to assign users to groups. Here is the sample User table.
ID Username Password Group

-------------------------------------

1 Bob Pass West

2 Bill Pass East

3 Mary Pass East

4 John Pass West

5 Jane Pass West
Main table

------------
Group Data1 Data2 Data3 ...

----------------------------------

West ...

West ...

East ...

West ...

East ...
I hope this helps a little bit.

Thanks, I have asked my Access creator to use the user-level security funtion within access then I think I will have a table that I can draw users from .... correct? Access is not one of my strong points. This is what sold me on your product. I can be pretty illiterate about access and get a database created by another on my web server.
Kudos to you for really coming through on your advertisement about the ease in which it is to set this up!!!!!!
You have certainly done all the leg work and deserve the money for this product.

Where is exactly I need to add this code in the check security function. Line # would be helpful or please show above/below or between codes.
if Session("AccessLevel")=ACCESS_LEVEL_ADMIN then

CheckSecurity = True

Exit Function

else

CheckSecurity = False

Exit Function

end if

This function can be found at the end of ..._list.asp file.

Function CheckSecurity(strValue, strAction)

I hope this helps.