VBA SQL Syntax - Problem with restricted keyword

[Arthur.J]

Hi All,
I am calling simple SQL Query in my code and getting error. I've checked and looks like query is not working because of "type" word inside query string which I believe is restricted. How I can fix it? Should I put this word in some quotas etc.?
Code is working fine for any other SQL query.

Thanks a lot in advance!

DBQuery ("select abt.type, abt.oid FROM cgs01.addressbook_type abt " _
& " "), "BK", 3

 

[Andrew Poulsom]

Try surrounding with [].

 

[Arthur.J]

Try surrounding with [].

I tried

[abt.type]

and

abt.[type]

still not working. Thanks anyway for quick reply.

 

[Andrew Poulsom]

It should work according to this:

http://msdn.microsoft.com/en-us/library/aa223962(v=sql.80).aspx

 

[Arthur.J]

It should work according to this:

http://msdn.microsoft.com/en-us/library/aa223962(v=sql.80).aspx

This query is working fine in any different sql editor. I've checked several time and any other table name is working fine except "abt.type". I'm using the same function for many other much more complicating queries.

[] is not working for me unfortunately.

 

[Andrew Poulsom]

You could also try single or double quotes.

 

[Arthur.J]

You could also try single or double quotes.

I did. I tried ""abt.type"", ''abt.type'', 'abt.type' and some more combinations. Still not working - it is really annoying. Spend half day to figure it out that this word is a reason for query not working.