Re: Strange "unspecified error" in D7/Access query


"Glenn Alcott" <galcott@xxxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:45365659$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:453650a6@xxxxxxxxxxxxxxxxxxxxxxxxx

I wonder if anyone knows why that field name would cause a problem.
This happens since Access treats Position as a reserved word, thus you
need
to quote it like this [Position].


I quoted it and that solved the problem. But I can't find any indication
in
the Access documentation that Position is a reserved word, and the query
works in Access itself without any quotes. Kind of strange. And why can't
the error message be more informative than "unspecified error"?
Who knows baby, who knows? :-)


.

Relevant Pages

  • Re: Error message on Where statement
    ... in the select are not using an aggregate function ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • RE: Error message on Where statement
    ... Good Luck ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)
  • Re: Strange "unspecified error" in D7/Access query
    ... This happens since Access treats Position as a reserved word, ... But I can't find any indication in ... Kind of strange. ... the error message be more informative than "unspecified error"? ...
    (borland.public.delphi.database.ado)
  • Re: Using a form to set criteria for a query
    ... When I get that error message, it means my query has more than one ... Caution! ... Access treats the word "name" as a reserved word. ...
    (microsoft.public.access.formscoding)
  • Error message on Where statement
    ... I seem to be missing something here. ... "The SELECT statement includes a reserved word or an argument name that is ... When OK is clicked on the error message, ... Name of TABLE: "Monthly Reports" ...
    (microsoft.public.access.queries)