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

Troubleshooting

Tracking Down Data Integrity Problems

You applied a validation rule to a database that already contained data. When Access tested the contents of the database against the rule you created, it found that some data violated the rule, but you 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