Username Password Help

[condor65]

Help, please. Boss asked me to setup an access 2000 db that can be accessed through the company intranet (frontpage 2000). Database is a table of employees skills. Users need to login using a ssn and password. Once ssn and pword are verified, the db would open only the part associated with the ssn. I can hit the database from frontpage, but I can't figure out setting up the login stuff (passing the username and password). Any help would be really, really, really appreciated.

Thanks

 

[Amiel]

I am aware that Access 2000 provides the means to 'web enable' your data without the use of .ASP. However I must ask, are you using IIS and Activer Server pages? Amiel
amielzz@netscape.net

 

[condor65]

Thanks,

Yes I am using both ASP and IIS. I have access to the web server also. I just need to setup a login so that users only get their piece of data in the database. I want them to login using SSN and a password. Once logged in, they would only be able to access info associated with their SSN.

Thanks again,

Mike

 

[Amiel]

I have only ever seen this accomplished using a session variable. In my thinking, this is the simplest way to accomplish this; the data will be secure and you job will be made simpler.

"...the db would open only the part associated with the ssn....". any procesing activity or logic that the IIS application may have will not be performed through MS Access, unless your plan is to create an instance of MS Access for this purpose. You'll be using the 'Jet Engine' and not MS Access for the application. You can use a password on the mdb file but again I've only ever seen security handled using logic hosted by IIS; either in an ASP page of a component.

A typical approach uses an HTML form with two text fields and a submit button.

Upon clicking the submit button the contents of the two text fields (ssn and password in this case) are sent to the page that will validate (or invalidate) the user and set the value of a session variable that will, for the life of the session (typically), determine what the user has access to.

Links or pages may appear or not appear based on this value, and program logic will execute (or not) based on this value.

I know that this does not answer your question exactly. But perhaps it can save you some hours of frustration.

Amiel
amielzz@netscape.net