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

Glenn Alcott wrote:

I wonder if anyone knows why that field name would cause a problem.

All SQL dialects have words that are reserved for special meanings. In
ANSI standard SQL you can still use a reserved word as the name of a
table or column but you must enclose the name in double quotes in a SQL
statement.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Sorting a Form
    ... Date is a reserved word. ... Try opening the query in design view and adding Ascending for the sort order ... see where ORDER BY occurs in the SQL. ... You have stated that you had "no luck" using ORDER BY after FROM Tbl_PIP, ...
    (microsoft.public.access.formscoding)
  • Re: Execute SQL SELECT statement with VBA code
    ... The reason Group doesn't work is because it's a "reserved word" in ... > The word "Group"in my SQL caused the problem. ... > "Sid" wrote in message ...
    (microsoft.public.access.formscoding)
  • Re: dataAdapter.Update() help! (bis)
    ... get the exact value that's being sent and I'm not sure if you are referring ... when you use a reserved word so that's why I mention it. ... > The SQL query in the dataAdapter.InsertCommand property seems OK, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Calculated Mean
    ... I copied your statement to SQL screen again but got the same error message. ... FROM Table1 AS T ... > After you get the error, copy what is in the SQL window and paste it intoa ... >> The SELECT statement includes a reserved word or an argument name that is ...
    (microsoft.public.access.queries)
  • Re: SQL syntax error???
    ... I believe 'Password' is a reserved word. ... > dbParams, Object& executeResult) ... > behavior, String method) ... > When I copy/paste the SQL directly into an Access query and run it it runs ...
    (microsoft.public.dotnet.framework.adonet)