Password protected info from a database

[SGT Buckeye]

I want to create a password protected web page that will allow my
employees to view their bonus earned. These bonus amounts will be in
an Access database. I want to start by having each person set up a
Username and Password which will be inserted into the database. Once
they have entered this information, I will add the bonus amounts
manually. Also, I want to set it up so they can pull the info from the
database using a form. Obviously, I will need to incorporate some kind
of filter to make sure that one person can not view another person's
pay. Can anyone suggest how I begin this project.

 

[Andrew Murray]

http://support.microsoft.com/default.aspx?scid=kb;en-us;825451
This link gives you a guide to doing the password protection bit. (it is a
basic way of doing this, it could installed on a secure server etc, but if
it's an internal thing, I don't know of that's really a concern; if security
over a computer network is of concern, bring in the experts to deal with
that.

You can enter the data in Access directly, and republish the database file
as required, as you've already mentioned.

The database results wizard will assist you to display the data.

Essentially, the search will match the username field and password, as long
as you don't have two "John Smith" in the company.
so the query will be something like:

Select * from EMPLOYEES where USERNAME = '::Username::' AND PASSWORD =
':ASSWORD::'.
This will return the record related to that employee where both fields
matched are "true".

Others here may have some ideas.

 

[Stefan B Rusynko]

Should be using a DB for the credentials
See http://support.microsoft.com/default.aspx?scid=321439

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| http://support.microsoft.com/default.aspx?scid=kb;en-us;825451
| This link gives you a guide to doing the password protection bit. (it is a
| basic way of doing this, it could installed on a secure server etc, but if
| it's an internal thing, I don't know of that's really a concern; if security
| over a computer network is of concern, bring in the experts to deal with
| that.
|
| You can enter the data in Access directly, and republish the database file
| as required, as you've already mentioned.
|
| The database results wizard will assist you to display the data.
|
| Essentially, the search will match the username field and password, as long
| as you don't have two "John Smith" in the company.
| so the query will be something like:
|
| Select * from EMPLOYEES where USERNAME = '::Username::' AND PASSWORD =
| ':ASSWORD::'.
| This will return the record related to that employee where both fields
| matched are "true".
|
| Others here may have some ideas.
|
| | >I want to create a password protected web page that will allow my
| > employees to view their bonus earned. These bonus amounts will be in
| > an Access database. I want to start by having each person set up a
| > Username and Password which will be inserted into the database. Once
| > they have entered this information, I will add the bonus amounts
| > manually. Also, I want to set it up so they can pull the info from the
| > database using a form. Obviously, I will need to incorporate some kind
| > of filter to make sure that one person can not view another person's
| > pay. Can anyone suggest how I begin this project.
|
|

 

[Andrew Murray]

Oops....I gave the wrong link, the one I wanted to give (wasn't the one
below)
but this one: http://support.microsoft.com/default.aspx?scid=kb;en-us;825498

 

[SGT Buckeye]

Thanks for the help and the link. I will try this and see what
happens. Again, many thanks.

Oops....I gave the wrong link, the one I wanted to give (wasn't the one
below)
but this one: http://support.microsoft.com/default.aspx?scid=kb;en-us;825498

Should be using a DB for the credentials
See http://support.microsoft.com/default.aspx?scid=321439

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| http://support.microsoft.com/default.aspx?scid=kb;en-us;825451
| This link gives you a guide to doing the password protection bit. (it
is a
| basic way of doing this, it could installed on a secure server etc, but
if
| it's an internal thing, I don't know of that's really a concern; if
security
| over a computer network is of concern, bring in the experts to deal with
| that.
|
| You can enter the data in Access directly, and republish the database
file
| as required, as you've already mentioned.
|
| The database results wizard will assist you to display the data.
|
| Essentially, the search will match the username field and password, as
long
| as you don't have two "John Smith" in the company.
| so the query will be something like:
|
| Select * from EMPLOYEES where USERNAME = '::Username::' AND PASSWORD =
| ':ASSWORD::'.
| This will return the record related to that employee where both fields
| matched are "true".
|
| Others here may have some ideas.
|
| | >I want to create a password protected web page that will allow my
| > employees to view their bonus earned. These bonus amounts will be in
| > an Access database. I want to start by having each person set up a
| > Username and Password which will be inserted into the database. Once
| > they have entered this information, I will add the bonus amounts
| > manually. Also, I want to set it up so they can pull the info from
the
| > database using a form. Obviously, I will need to incorporate some
kind
| > of filter to make sure that one person can not view another person's
| > pay. Can anyone suggest how I begin this project.
|
|

 

[SGT Buckeye]

Okay group...is there a work around that will allow me to do this
without using ASP pages. My company has two servers: one that supports
ASP and one that does not. The server that my team's web site will be
on does not support ASP pages. Our IT guy explained to me a really
technical explanation for this but it made my head hurt trying to
figure out what it all meant. I appreciate the assistance.

 

[Guy Lapierre]

Ask the "techie" what is available in lieu of ASP on that server and we may
be able to give you some guidance. This is server side stuff and you will
only be able to use what the host is providing as tools.

 

[Andrew Murray]

MS Access is a Windows application and won't work on Linux/Unix.

To access the data in an Access database you would be required to use the
database components in FP or write your own (or get a programmer to do so).
ASP scripts would be required, and a Windows server.

Otherwise using Perl or PHP (server-side scripting languages for Linux/Unix)
would be needed to manipulate the data in a MySQL database. (Again, if you
need expertise, perhaps a professional developer is the best person to
approach....it sounds like something beyond what Frontpage can offer.