I have an access 2003 with Access Data Access Pages that are accessed over the Internet. I would like to Add security to the application. So, far I I have a Login page that allows the end-user to enter their name and password and when they click login the end-user is forwarded to the application main menu. The login page was developed in ASP and the on-click event checks the Access database employee table to verify if the end-user exist.
How can I protect the Data Access Pages to prevent someone from just typing in the site URL address and Data Access Page Name? For example, When a person goes to a web application on-line like experts-exchange .com they have to sign in to view data, a solution, and or ask a question and sign off or just close the web browser when done. The user can't just go to the question Wizzard without by typing in the URL address, the user has to login.