OleDbCommand syntax error 0x80040E14 in SELECT Statement

Question

This query runs perfectly in Access 2010:

SELECT te.[EnterpirseName], COUNT(to.[ID]) AS Orgs, SUM(to.[Members]) AS Mems
FROM tbl_Enterprise AS te, tbl_Organizations AS to
WHERE to.[Enterprise_ID] = te.[ID] AND te.[Status] = 1
GROUP BY te.[EnterpirseName]

However when I try to execute it from my C# winforms application, I get syntax error:

0x80040E14 Syntax error near keyword FROM

EDIT: My C# code:

string strCommand = "SELECT te.[EnterpirseName], COUNT(to.[ID]) AS Orgs, SUM(to.[Members]) AS Mems" +
    " FROM tbl_Enterprise AS te, tbl_Organizations AS to" +
    " WHERE to.[Enterprise_ID] = te.[ID]" +
    " AND te.[Status] = 1" +
    " GROUP BY te.[EnterpirseName]";

DataTable dt = new DataTable();

using (OleDbConnection conn = new OleDbConnection(strConnString))
{
    OleDbDataAdapter da = new OleDbDataAdapter(strCommand, conn);

    using (DataSet ds = new DataSet())
    {
        // THIS IS WHERE I GET THE ERROR
        da.Fill(ds);
        dt = ds.Tables[0];
    }
}

That's how strCommand looks like in Debug:

Why `" FROM tbl_Enterprise AS te, tbl_Organizations AS to" +` ?You have to use joins for two tables — Hemal, Feb 03 '17 at 05:14
In debug; what do you see as strCommand? Seems to me as some typo — A3006, Feb 03 '17 at 05:15

score 2 · Accepted Answer · answered Feb 03 '17 at 05:32

2

TO is a reserved word in Access as well. Try to replace it to something like tbl_Org.

answered Feb 03 '17 at 05:32

FireFalcon

831
11
23

score -2 · Answer 2 · answered Feb 03 '17 at 05:23

-2

Are you sure your c# app isn't using another engine, like SQL Server? In SQL Server, TO is a reserved word, so you should use [To] instead.

answered Feb 03 '17 at 05:23

faibistes

125
6

My whole application works with only one DB that is in Access. – firefalcon Feb 03 '17 at 05:28

OleDbCommand syntax error 0x80040E14 in SELECT Statement

2 Answers2