Membership Database

[BMuntz]

Hi,
I am not a bad HTML'r but suck at databases. I used the form generator to
create a membership database. (MDB FILE) I know how to set up the ODBC. What
I need to do now is to have a user sign in for privledged areas of the
website. I would need some kind of code to check if a user has signed in or
not and as well a logout I guess. Also, I would like to use a validater of
some sort to verify the user signing up for membership... such as email
validation, a user gets an email and has to click a URL link to validate
before the information is stored in the database. I use FP 2003. Once again,.
I am terrible at datbase structured language so please be verbose. Alot of my
friends tell me I should use PHP. I don't now PHP and I really don't have the
time to learn a new lanuage. Your help is very much appreciated.
-Brian (e-mail address removed)

 

[Stefan B Rusynko]

Whether you use PHP or ASP depends on your server and what they support
(DB type and server side script language)
In either case you will either have to
- learn to hand code serve side scripting
- search for a pre-built membership management web based app that is supported (DB type and server side script language) by your
host

--

_____________________________________________
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
_____________________________________________


| Hi,
| I am not a bad HTML'r but suck at databases. I used the form generator to
| create a membership database. (MDB FILE) I know how to set up the ODBC. What
| I need to do now is to have a user sign in for privledged areas of the
| website. I would need some kind of code to check if a user has signed in or
| not and as well a logout I guess. Also, I would like to use a validater of
| some sort to verify the user signing up for membership... such as email
| validation, a user gets an email and has to click a URL link to validate
| before the information is stored in the database. I use FP 2003. Once again,.
| I am terrible at datbase structured language so please be verbose. Alot of my
| friends tell me I should use PHP. I don't now PHP and I really don't have the
| time to learn a new lanuage. Your help is very much appreciated.
| -Brian (e-mail address removed)

 

[Thomas A. Rowe]

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321439

Applies to FP2000 thru FP2003

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Ronx]

First find out what your host will support. Access databases (.mdb) will
not work on Unix servers.
You will have to learn a scripting language, either ASP or PHP (or asp.NET,
Perl/CGI, etc) depending on your host.

For a Windows server using ASP and Access, see:
Protect individual pages: (Requires Windows Server with support for ASP
and Access database)
http://support.microsoft.com/default.aspx?scid=kb;en-us;825498

This shows how to control access to pages from a database of users, but you
still need to build that database.

It sounds like you need to employ a skilled programmer.

 

[BMuntz]

Thanks Thomas for the link. Why I could not find that one myself is beyond
me. I searched for over 3 hours.

 

[BMuntz]

Hi Ronx,

Thanks for your reply. I am the ISP in a sense. I have a business DSL static
IP connection and host all my own services. My web is W2K server IIS 5.0. I
have installed ASP.NET and ASP 1.1 and all the latest patches. I also have
ASPemail and ASPupload installed as well with mySQL, PHP, PERL and God
$knows() what else. End if. LOL

I am going to try Thomas' solution at the MS link example ASP. See if I can
muttle my way arround that. If you have anything else to contribute, please
do.

-Brian