Microsoft KB Archive/164482

= ACC97: No Error Message with Delete or Commit on ASP Pages =

Article ID: 164482

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q164482



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you try to delete or update a record on an Active Server Page (ASP), the record is not deleted or the change is not made. However, you do not receive an error message letting you know that the deletion or modification failed. If you try to delete or update the same record when the form is open in Microsoft Access 97, you receive an error message letting you know the record could not be deleted or the change could not be made.



CAUSE
Your form is based on a table that is participating in referential integrity, contains required fields, or contains fields with validation rules.



MORE INFORMATION
Records will not be deleted if the table that the record is in is on the one-side of a one-to-many relationship and the many-side table contains related records.

Updates to fields will not be committed if they do not conform to the Required and Validation Rule properties of the table that the form is based on. Updates to fields participating in referential integrity on the one- side of a one-to-many relationship will not be committed if there are related records in the many-side table.

This behavior can also occur if both of the following conditions are true:


 * The ASP files are located on a server running a version of Microsoft Personal Web Server that is earlier than 4.0 or a version of Microsoft Internet Information Server that is earlier than 4.0.
 * You are trying to update a field with data that is longer than the size of that field. For example, you are trying to enter a 15-character string into a text field whose FieldSize property is set to 10.

If you try any of these scenarios directly in Microsoft Access, you will be prevented from doing so and you will be warned. In the ASP form, however, there is no error trapping and no warnings; the attempted action fails without warning.

Steps to Reproduce Behavior
 Open the sample database Northwind.mdb in Microsoft Access 97. Open the Customers form and try to delete the first record. Note that you receive the following error message:

The record cannot be deleted or changed because table 'Orders' includes related records.

 Click OK to the error message. Save the form as an Active Server Page. Open the newly exported form on your Web browser. Scroll down to the bottom of the form and click Delete.</li> In the "Press OK to delete current record" box, click OK. Record two becomes the current record.</li> Scroll down to the bottom of the page, and select the record selector to return to the previous record. Note that the record you tried to delete still exists.</li></ol>

<div class="references_section">