CODEWITHSUNDEEP
sqlsql-serverms-accessms-access-2010
Prashant Khadatkar
Prashant Khadatkar

Reputation: 200

MS Access database: Select statement error

I am trying following query in MS Access 2010 database:

Query:

SELECT     ID, Title, Priority, Workflow_Instance_Step_ID:ID
FROM         Task

Error:

Error Source: Microsoft Office Access Database Engine Error Message: Syntax error (missing operator) in query expression 'Workflow_Instance_Step_ID:ID'

I know that field "Workflow_Instance_Step_ID:ID" is giving error as it has ':' operator, but I cant change it as it it coming from share point list.

I have tried '[Workflow_Instance_Step_ID:ID]' but still its giving an error. Please give me your suggestion on the same.

Upvotes: 0

Views: 416

Answers (2)

donPablo
donPablo

Reputation: 1959

So we might be in diagnosis mode, so lets try

    SELECT * FROM Task

and then look at the FieldNames that come back.

Upvotes: 0

Gord Thompson
Gord Thompson

Reputation: 123654

I am unable to recreate your issue, at least with a native Access table in Access 2010. I created a table named [baz] with a single text field named [foo:bar]

foo:bar
-------
this   
is     
a      
test

and the query

SELECT [foo:bar] FROM baz;

works fine, so a field name containing a colon character does not seem to cause problems for Access SQL as such.

An ODBC linked table to a SQL Server table with the same structure does not cause problems either.

In both cases the queries were run from within Access 2010 itself.

Upvotes: 1

Related Questions