Recent content by scrub55434

I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here So I'm pretty sure...

Link to the original thread I have realized what I was doing wrong and thought that I would post the solution in case anyone else does the same trying to implement security. First off thanks Pat Hartman for the input. You were right on there needing to be a cutoff and now one is added that...

That is a good point, in most cases that would make sense. But I think it does in ours. There are 4 people involved, building manager, operation manager, general manager and systems administrator. The mass majority of the time the building manager will be the only one making changes to the...

Thanks for the input. That makes sense. Can you think of a better way to structure this? I tried connecting tblMangerBuildings.BuildingNum to tblShifts.building thinking that this would connect the shift to the user but it had the same results. As a workaround I created a trigger that set a...

Users are seperate from employees. The username will match the Windows Authentication username. The users will be managers that aren't in the employee database because they don't clock in or out. I could combine them but there are going to be 150 employees and under 5 users.

Screen view of Database Diagram Screen view of problem view I am working with a Access Data Project and MSDE database server. In the image you can see the tables that I am working with. I have a table, tblShifts, that has all of the shifts with clock in and out times for all buildings. I am...

Screen view of the database diagram Screen view of the query I am working with a Access Data Project and MSDE database server. In the image you can see the tables that I am working with. I have a table, tblShifts, that has all of the shifts with clock in and out times for all buildings. I am...