I have an Access 2K database and query that joins two table, qryCoilUsage.

When attempting to execute a specific query againt the query, "SELECT * FROM qryCoilUsage WHERE Line Like '%' AND Section Like 'Z%'" I recieve an error message "method of object ~" etc.

The query is being executing in ADO thus the % and not the *

This problem is odd!?!

I am not aware of Section being a keyword. But, as a preventitive measure I prefixed it with the table name. This resulted in the same error.

This query is dynamic and doesn't always include the Section column the only time the problem exists is on the Section column. I changed the name of the column to Secttion and the query accordingly, just to humor myself, and it executed fine.

I also ran the query in Access and it ran fine as well. Yes, I had to change the % to an *.

So, I suspect the problem is in the ADO object and somehow related to word Section?

Any help would be greatly appreciated.

Thanks in advance,

Larry

Larry Asher

__________________
Larry Asher

Looks lile section is reserved for ODBC & SQL Server so I guess this follows through to the ADO libraries also:

http://aspfaq.com/show.asp?id=2080

http://msdn.microsoft.com/library/de...ra-rz_9oj7.asp

The documentation was great! I really appreciate you taking the time to reply. Thanks

Larry Asher

Hi!!
U may be right. try to put the word section like this in the query [section]... e.g.
the query written below runs fine both is SQL and in Access 2K.

select * from [com-link] where [sn] like '*' and [desc] like 'd*'

Bye
Arnab