Mystery Parameters

[Dukelewis]

I am organizing and renaming tables and queries in a database. My queries automatically update the new table and query names when I view them in Design mode. However, when I click on Datasheet view it asks for parameters from tables I have renamed. I looked at the parameter dialog box under the query window but no parameters were listed. I examined the SQL and the old table names are not there either. Is this a bug in Access or do I need to change the names somewhere else in the Design mode?

 

[Rich_Lovina]

This is a common problem when one of your table names or field names are not recognised (i.e. most likely a typing error). Check all very carefully again, and the pop-up box will have as its subject the information piece not recognised.

 

[Dukelewis]

Thanks for the help. I sniffed out the errant code.