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


"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"?


.

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 ... 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)