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

ID: Q164482

The information in this article applies to:

Microsoft Access 97

SYMPTOMS

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

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.

In the "Press OK to delete current record" box, click OK. Record two becomes the current record.

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.

REFERENCES

For information about permissions necessary for IDC/HTX files, please see the following article in the Microsoft Knowledge Base:

Q160754 ACC97: Error "HTTP/1.0 403 Access Forbidden" Browsing IDC Page

Additional query words: can't cannot


Keywords          : kbinterop IntPubWiz FmsOthr IntAsp 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 26, 1999