• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Tracking Down Data Integrity Problems

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.

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint