Re: VB MS Access Syntax error in FROM clause Error

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/27/04 

Date: Wed, 26 May 2004 23:30:49 -0400

Hi,

Usually this error generated in a case when table name or some of the fields
in a query are reserved words. Could be that Project is a reserved word or
some of the fields. In this case you need to wrap these names into square
brackets, like

SELECT [name], ... FROM [Project] .... 

-- 
Val Mazur
Microsoft MVP
"VB MS Access Syntax error in FROM clause" <carl244541@yahoo.com> wrote in 
message news:513DB8B4-54DB-432B-9F98-A96054DECB36@microsoft.com...
>I have a program that is recieving the following error "Syntax error in 
>FROM clause." and I am not sure why anyone have any ideas, here is the 
>code:
>
>            strSQL = "SELECT * FROM Project Where ProjectID=" & 
> Val(PrjID.Text)
>            Set rNew = New ADODB.Recordset
>            rNew.CursorLocation = adUseClient
>            Call OpenAccessConnection(cnn, gDBNameandPath)
>            rNew.Open strSQL, cnn, adOpenKeyset, adLockBatchOptimistic, 
> adCmdTable
>
> it occurs on the open, any help would be appreciated.
>
> carl

Relevant Pages

  • Re: problem to SELECT using Microsoft Access (posted again, because of posting error)
    ... I tested that query. ... I get an error "syntax error in from clause" which is ... becuase Table is a reserved word ...
    (borland.public.delphi.database.ado)
  • Re: probably not as complex as Im thinking...
    ... No, sorry, I get a syntax error in Group By clause here, and I tried not ... >> OK, I have 4 queries, the SQL view of which I have below, with brief ... Please understand that I use the Query Design Grid to make ...
    (microsoft.public.access.queries)
  • Re: GROUP BY clause not working
    ... using PEAR and I'm getting DB Error: Syntax Error when using the GROUP ... you cannot use columns in a query containing a GROUP BY ... clause, unless they are part of the clause or an aggregate function. ... SELECT LocationID FROM HardwareInstallationsSummary WHERE LocationID = ...
    (comp.lang.php)
  • Re: GROUP BY clause not working
    ... using PEAR and I'm getting DB Error: Syntax Error when using the GROUP BY clause. ... Here's my query: ... SELECT * FROM HardwareInstallationsSummary WHERE LocationID = $loc_ID GROUP BY EquipmentTypeID ...
    (comp.lang.php)
  • Re: MS Access SQL Like
    ... > sequencing and with reserved words. ... > their appearance in the query must match the exact order that they are ... > parameterized queries instead of regular dynamic sql] treats the comma ... > It's actually worse b/c chances are nothing will match. ...
    (microsoft.public.dotnet.framework.adonet)