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

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

1. Open the sample database Northwind.mdb in Microsoft Access 97.
2. 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.
3. Click OK to the error message.
4. Save the form as an Active Server Page.
5. Open the newly exported form on your Web browser.
6. Scroll down to the bottom of the form and click Delete.
7. In the "Press OK to delete current record" box, click OK. Record two becomes the current record.
8. 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.