|
Environment:
Windows 2000 Server
IIS 5.0
Access 2003
IIS is set up for basic authentication. This means I can set rights for logged in users using NTFS file permissions. This all works well for simple protection of a few pages. I have several web pages that allow employees from different departments to enter order statuses, deliveries, schedules, etc. The web pages were developed using Access's data access pages. I've done very little with ASP, but it is installed on the Server. Also security is not a big deal here because this is all done on inside and MaBell handles our firewalls.
My next project is to create an ordering system where employees can put in orders to another manufacturing department. This is all a bit more advanced that what I've done so far.
The new Access DB will have a users table. It will have fields for their name, phone number, and a field that is the same as their login user name.
I need to match the user name they login with to the user name in the table so I can deliver content based on the users needs. Once I get the windows authenticated user name matched to a field in a table I can move quickly from there I think.
Thanks,
James
|