Re: ASP Login Database to Online Form Registration

On Jul 2, 2:40 pm, "Mike Brind [MVP]" <paxton...@xxxxxxxxxxx> wrote:
"Jason" <ci0...@xxxxxxxxx> wrote in message

news:a0325a9c-5e5e-4bd4-b52e-6de0b1a9bbdf@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 1, 10:16 pm, "Bob Lehmann" <nos...@xxxxxxxxxxxxxxxx> wrote:





****************
If somebody wants to change his/her username, you don't have
to change any records in the CHILDREN table. This is called
"NORMALIZATION".
****************

Actually it's not normalization, it's referential integrity, which really
has not much to do with normalization.

Although I wouldn't use the username as the key either, a cascading update
would solve the problem you describe.

Bob Lehmann

"Old Pedant" <OldPed...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:16348178-40BE-4B69-A38B-48046AED034C@xxxxxxxxxxxxxxxx

Sounds fine to me.

Until you mentioned the idea of many children for one username, I was
ready
to ask why you even bothered with two separate tables. No reason you
couldn't use one table that is partly filled in by one page and partly
by
another.

That *STILL* might be the right idea for data that is common for all
children. Example: parent's phone number, address, parent's age, etc.

So you *ONLY* put in the child-specific stuff to the CHILDREN table.

One minor thing: Commonly, we use an autonumber field as the primary key
in
the PARENTS table. And then use integer field as foreign key in the
CHILDREN
table. Reason: If somebody wants to change his/her username, you don't
have
to change any records in the CHILDREN table. This is called
"NORMALIZATION".

But for a small DB, it's not a big issue. Username works fine.

[My own preference is to use EMAIL as the username and then the
autonumber
field as primary key. Since EMAIL is always unique, you won't have the
problem of two people trying to use the same username. But, again, this
is
implementation detail, not affecting the concepts.]

Did that help or make things worse?

"Jason" wrote:

Hey. I'm just starting to learn ASP and I'm trying to figure out to do
things. What I want to do is have a Login page as well as a Create
Account page (both is ASP). The user would create an account (username
and password) which would be put into an Access databse. Then they can
Login, and would take them to a Registration Form page, if their user
info is validated against the database.

Once they've gotten to the form page, they'll need to fill out the
form, submit it, and that info would be put into the database as well
(same database, just different table). What I figured I could do is
have the Username as the primary key for both tables so that if a user
logs back in to make any changes, it could pull the info from the
table and fill in the fields they previously filled in so when they
submit it again, it would overwrite what they previously put it.

Now here's a tricky part. This is a student registration, so lets say
a parent wants to register several children each at different schools,
and use the same Username/Password, I was thinking of just having it
put a seperate entry into the 'registration' table with the same
Username. That way when we go to look these up when the parent comes
in to sign paperwork, we can pull up the info by the Username, since
there are probably going to be people with same name.

Any help would be appreciated. Thanks.
~ Jason- Hide quoted text -

- Show quoted text -

Thanks. Makes sense.

Are there any good ASP scripts out there working with 'creating an
account' and 'login' pages?

~ Jason

Loads probably.  Trywww.aspfree.comfor starters.

--
Mike Brind
Microsoft MVP - ASP/ASP.NET- Hide quoted text -

- Show quoted text -

Thanks everyone. I've got it working. My next dilemma is to create
page for users to be able to edit information (students) they
submitted based on their login info. So a person would login, which
would take them to a page where they could click to "Sumit a new
student" as well as list the students' name they've already register/
submitted, which they can click to edit that entry/student info. When
they click on the student name, it would take them to the form with
all of the information in it pulled from the database (Access).

P.S. - Using ASP


Thanks in advance.
~ Jason
.

Relevant Pages

  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)
  • RE: Receiving JDBC error when executing program - Login failed for user sa
    ... says we're using 'sa' so I would think that's the username being passed in. ... | I am receiving the following error when attempting to run my database ... I tried to login the 'sa' account ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Dynamic SQL
    ... Don't need to login to the database. ... OF course entering username N00bHax0r') will cause an error. ... // is the Validators good for this ????? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Login fails. Why?
    ... the 'UserName' login has not been granted access to the ... The user will need permissions on referenced database objects, ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Synchronize Active Directory with a SQL-Server database
    ... users of the Active Directory. ... on the login I check if the user exist in the AD too. ... username and the password on the database. ... So I need the record of the users in the database to have the same ...
    (microsoft.public.windows.server.scripting)