Troubleshooting

Field Property Values Cause Paste Failures

Access beeps when I attempt to paste data into a cell.

The paste operation would violate a domain or referential integrity rule, usually the Field Size property value. For instance, if you attempt to paste more than five characters into the CustomerID field of the Customers table, the paste operation fails without an error message. Make sure that the cells or blocks of cells you paste conform to Field Size and other data validation rules.

Multiple Record Selection Causes Silent Paste Failures

Nothing happens when I try to paste data into a cell.

Selecting multiple records, then attempting to paste the records into a single cell, even the first cell of the tentative append record, results in a silent paste failure. Access limits multiple-record insert operations to the Edit, Paste Append command.

Error Messages from Validation Enforcement

Error messages appear when I enter data in fields with validation rules.

Edit or re-enter the data to conform to the data types and validation rules for the field. Error messages that appear when you enter the data correctly indicate that something is amiss with your validation rules. In this case, change to design mode and review your validation rules for the offending fields against those listed in Table 6.6. You might want to remove the validation rule temporarily by selecting the entire expression and cutting it to the Clipboard. (You can paste the expression back into the text box later.) Return to Run mode to continue with your entries.