Username and Password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form to use for my password protected webpage. On the page
where the new user creates a username and password the form is automatically
sent to the access database. Is there a way to also send a notification to my
email letting me know that a new user has registered?
 
Hi There is a paper which microsoft have writen to do this but I don't know
theURL but someone will on this forum

I have found another easy solution if you don't want the results sent to
your email just notification of an addition to the database
Create a page called say database_entry_confirmation.asp
and add the code below
In your form properties set the confirmation page to
database_entry_confirmation.asp
when the form is submited the confirmation page will will send you an
email

Put this in the head this stops search engines logging the page so it won't
be triggered accidentally

<%
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "Cache-Control", "must-revalidate"
Response.AddHeader "Cache-Control", "no-cache"

%>

'And this sends you the email just change the email addreses to yours
You can use any email script you like here


<% 'Sends email notification of new entry

Dim myCDONTSMail
Dim strFrom
Dim strTo
Dim strSubject
Dim strBody

strFrom = "youremail address here"
strTo = "youremail address here"
strSubject = "New database entry"
strBody = "A project has been added to the database " & Chr(13)
Set myCDONTSMail = CreateObject("CDONTS.NewMail")
myCDONTSMail.Send strFrom,strTo,strSubject,strBody
Set myCDONTSMail = Nothing
Else
end if
%>
 
Not if you're using the FP form handler (database wizard) that writes to the
database.

You'd need a third party script that does a proper job of "user
registration" or "user management" (including the ability to email forgotten
passwords, confirming that an actual user has registered by providing the
"click on this link to confirm" type feature (to avoid spam bots
auto-signing up) and so on).

One site that offers a multitude of scripts in multiple formats is
www.hotscripts.com which I use often, but there's many more out there.
 
Back
Top