|
|
Error Code: 3061 In general, when DAO process a query and find a name it cannot associate with a table or other object, it assumes that the name is actually a parameter though that may not have been the author's intention to use a parameter. The error message may return a different N depending on how many "parameters" is missing which gives you an indication of how many errors you may need to fix.
[edit] Possible Causes and Resolutions[edit] Typo and/or Misspelling of ObjectsDouble check that every columns you have selected and use in filtering are correctly spelled. [edit] Missing reference to tables or other queriesEnsure that there are tables and/or queries in the FROM clause present to satisfy all columns references in the SELECT, GROUP BY, ORDER BY. Also, if you are using subqueries or stacking queries, verify that the subquery has the columns as part of the SELECT part so the outer query can properly reference the column from the subquery. [edit] Incorrectly delimited with []If you have a "[Foo]", Access will interpret this as an object reference; if you mean to pass in only a string "Foo", remove the [] delimiter to signal to Access that this should be a literal
|
| This page was last modified 18:27, 14 October 2010. This page has been accessed 2,036 times. Disclaimers |