Troubleshooting

Missing Objects in Queries

When I run my query, an Enter Parameter Value dialog appears that asks me to enter a value. I didn't specify a parameter for the query.

The Enter Parameter Value dialog appears when the Jet engine's query parser can't identify an object specified in the query or evaluate an expression. Usually, the Enter Parameter Value dialog appears because of a typographic error. Intentionally creating parameter queries is the subject of this chapter's "Designing Parameter Queries" section.

Queries with Linked Tables Aren't Updatable

I can't create an updatable one-to-many query with my linked dBASE or FoxPro tables despite the fact that my query displays only fields from the many side of the relationship.

You must specify (or create) primary-key indexes for each dBASE or FoxPro table that participates in the query. The field or fields that you choose must uniquely identify a record; the index doesn't allow duplicate values. Delete the attachment to the dBASE or FoxPro tables and then reattach the table with the primary-key indexes. Make sure that you specify which index is the primary-key index in the Select Unique Record Identifier dialog that appears after you attach each table.

Also, make sure that you don't include the field of the many-side table on which the join is created in the query. If you add the joined field to the field list, your query isn't updatable.