Stop Fooling Database Entry Users

  • Thread starter Thread starter Mark Entzminger
  • Start date Start date
M

Mark Entzminger

I have a web form that allows users to enter information in a web
form. Two fields (username and email) are set in Access 2007 to Index
(No Duplicates), however when testing the forms duplicate entries are
not created in Access, however the website functions as if the
username and email were unique when in fact they are not.

My question is: How do I

1. Verify the information entered into the form prior to clicking the
submit button

OR,

2. How can I tell front page to display an error message that stating
the username or email is already in use?

I'm using FP 2003, Access 2007, Windows XP
 
I have a web form that allows users to enter information in a web
form.  Two fields (username and email) are set in Access 2007 to Index
(No Duplicates),  however when testing the forms duplicate entries are
not created in Access, however the website functions as if the
username and email were unique when in fact they are not.

My question is:  How do I

1.  Verify the information entered into the form prior to clicking the
submit button

OR,

2.  How can I tell front page to display an error message that stating
the username or email is already in use?

I'm using FP 2003, Access 2007, Windows XP
Click to expand...

The form was created using the Database Interface Wizard. Not sure if
that piece of information makes a difference or not.

Thanks.
 
Back
Top