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

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 displays an Enter Parameter Value dialog box. Regardless of what I enter, the query doesn't work properly.
A1: This problem is almost always caused by a typo in a field name. Field names and parameters both appear inside brackets. If you misspell a field name, especially in an expression used with a calculated field, Access can't find the field and therefore assumes you want to display a parameter dialog box. Go through every expression in the query and see whether you can find (and fix!) the typo.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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