I created a Web page using FrontPage Database Wizard so that users can add record into an SQL server. I selected to use ASP.NET. It is working ok, but everytime a user clicked the Submit button without filling in a required field, the database generate error for this user and the next users will not be able to access the database anymore unless I stopped and restart SQL server. Is there a way to prevent this from happening?

Thanks!

OD

If you have form field validation, then the users should not be able to submit the form.

--
==============================================
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.
==============================================

"OD" <(E-Mail Removed)> wrote in message news:eToIR$(E-Mail Removed)...
I created a Web page using FrontPage Database Wizard so that users can add record into an SQL
server. I selected to use ASP.NET. It is working ok, but everytime a user clicked the Submit button
without filling in a required field, the database generate error for this user and the next users
will not be able to access the database anymore unless I stopped and restart SQL server. Is there a
way to prevent this from happening?

Thanks!

OD

They are not able to submit because there is validation on their they get
the correct error message. However, after that, no one can add data to the
database on the same table until the SQL server service is restarted. Any
Ideas?

--
OD
"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> If you have form field validation, then the users should not be able to
> submit the form.
>
> --
> ==============================================
> 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.
> ==============================================
>
> "OD" <(E-Mail Removed)> wrote in message
> news:eToIR$(E-Mail Removed)...
> I created a Web page using FrontPage Database Wizard so that users can add
> record into an SQL server. I selected to use ASP.NET. It is working ok,
> but everytime a user clicked the Submit button without filling in a
> required field, the database generate error for this user and the next
> users will not be able to access the database anymore unless I stopped and
> restart SQL server. Is there a way to prevent this from happening?
>
> Thanks!
>
> OD
>
>

If no one can submit after a failed attempt, then you have more then just form field validation
setup on your form.

--
==============================================
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.
==============================================

"OD" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> They are not able to submit because there is validation on their they get the correct error
> message. However, after that, no one can add data to the database on the same table until the SQL
> server service is restarted. Any Ideas?
>
> --
> OD
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> If you have form field validation, then the users should not be able to submit the form.
>>
>> --
>> ==============================================
>> 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.
>> ==============================================
>>
>> "OD" <(E-Mail Removed)> wrote in message news:eToIR$(E-Mail Removed)...
>> I created a Web page using FrontPage Database Wizard so that users can add record into an SQL
>> server. I selected to use ASP.NET. It is working ok, but everytime a user clicked the Submit
>> button without filling in a required field, the database generate error for this user and the
>> next users will not be able to access the database anymore unless I stopped and restart SQL
>> server. Is there a way to prevent this from happening?
>>
>> Thanks!
>>
>> OD
>>
>>
>
>