Queries work in Access but not via ASP/ADO

I am having problems with queries submitted to a Microsoft Access
database by ASP via a DSNless ADO connection.

An example of the query is:

SELECT DISTINCT Documents.Document, Documents.Title FROM (Keywords
INNER JOIN LinkTableKeywordLink ON Keywords.ID =
LinkTableKeywordLink.KeywordID) INNER JOIN (Attachments INNER JOIN
((LookUpSubject INNER JOIN Documents ON LookUpSubject.Id =
Documents.Subject) INNER JOIN LinkTableAttachments ON
Documents.Document = LinkTableAttachments.DocumentID) ON Attachments.Id
= LinkTableAttachments.AttachmentID) ON LinkTableKeywordLink.DocumentID
= Documents.Document WHERE (((Documents.Title) Like '*test*')) OR
(((Documents.Author) Like '*test*')) OR (((Documents.Summary) Like
'*test*')) OR (((Keywords.Keyword) Like '*test*')) OR
(((Attachments.AttachmentTitle) Like '*test*')) OR (((Attachments.Path)
Like '*test*')) order by Title;


This works perfectly within Access but not when submitted via ASP.
Simpler queries (with joins) work fine. It seems to be when I perform
"like" wildcard queries as above.

Any thoughts?

You don't need to use the *s But if you want to use wildcards use an
sql standart: Try with % instead of *

Be lucky



StevePBurgess.TakeThisOut@gmail.com wrote:
> I am having problems with queries submitted to a Microsoft Access
> database by ASP via a DSNless ADO connection.
>
> An example of the query is:
>
> SELECT DISTINCT Documents.Document, Documents.Title FROM (Keywords
> INNER JOIN LinkTableKeywordLink ON Keywords.ID =
> LinkTableKeywordLink.KeywordID) INNER JOIN (Attachments INNER JOIN
> ((LookUpSubject INNER JOIN Documents ON LookUpSubject.Id =
> Documents.Subject) INNER JOIN LinkTableAttachments ON
> Documents.Document = LinkTableAttachments.DocumentID) ON Attachments.Id
> = LinkTableAttachments.AttachmentID) ON LinkTableKeywordLink.DocumentID
> = Documents.Document WHERE (((Documents.Title) Like '*test*')) OR
> (((Documents.Author) Like '*test*')) OR (((Documents.Summary) Like
> '*test*')) OR (((Keywords.Keyword) Like '*test*')) OR
> (((Attachments.AttachmentTitle) Like '*test*')) OR (((Attachments.Path)
> Like '*test*')) order by Title;
>
>
> This works perfectly within Access but not when submitted via ASP.
> Simpler queries (with joins) work fine. It seems to be when I perform
> "like" wildcard queries as above.
>
> Any thoughts?