Special Edition Using Microsoft® Office XP

Troubleshooting

Tracking Down Data Integrity Problems

Q1:	I applied a validation rule to a database that already contained data. When Access tested the contents of the database against the rule I created, it found that some data violated the rule, but I don't know which records need to be edited.
A1:	Frustrating, isn't it? Testing your validation rule tells you only that a problem exists; it doesn't tell you which records are incorrect. To find and fix the invalid data, copy the contents of the rule and create a query that uses the same criteria. If necessary, edit the values in the query result datasheet, and then re-create the rule.

Is It a Parameter or a Typo?

Q1:	I created a simple select query without parameters, but when I run it, Access ...