Activate account by link in e-mail

[gorden blom]

Hello,

I'm working on a school project about asp.net and I have a question
about an activation link in an E-mail. I created a form at witch new
users can subscribe. This form add the new user to an Access database
and an E-mail is sent to the e-mail adress the new user entered. This
link should set a boolean value(active) to true so the new user can
start using his account.

Can anyone tell me how to create a link like this, or can anyone give
me an example for this kind of problem? The only thing what the link
should do is update an existing record in the database so the user can
start using his account.

Thanks in advance,

Gorden Blom

[Wim Hollebrandse]

When someone subscribes - you simply generate a unique identifier, using
static NewGuid() method on the Guid class.

You insert this Activation Guid into the database against this user. Also,
you set some Active field to 0 by default.

Also - you use this Guid in the link in the e-mail and when this is
clicked - you update the record for this activation Guid and set it's active
flag to 1.

Hope that gives you an idea of the process.

Cheers,
Wim Hollebrandse
[url]http://www.wimdows.com[/url]
[url]http://www.wimdows.net[/url]

"gorden blom" <gordenblom@hotmail.com> wrote in message
news:8c25c8c2.0307151134.1300dc6f@posting.google.c om...

> Hello,
>
> I'm working on a school project about asp.net and I have a question
> about an activation link in an E-mail. I created a form at witch new
> users can subscribe. This form add the new user to an Access database
> and an E-mail is sent to the e-mail adress the new user entered. This
> link should set a boolean value(active) to true so the new user can
> start using his account.
>
> Can anyone tell me how to create a link like this, or can anyone give
> me an example for this kind of problem? The only thing what the link
> should do is update an existing record in the database so the user can
> start using his account.
>
> Thanks in advance,
>
> Gorden Blom

[gorden blom]

Thank you for helping me! Now I know where I'm looking for, this
should be a lot easier.