Discussion Locked

Access/ASP problem

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I get this error every time my asp trys to perform a search on my access database. The funny thing is it only happends when I try to use the contains or like criteria which is what I need. If I set it for equals and put in the exact text it works fine. Some help would be appreciated. This is a standard text field.

3 replies

by cdiaz

The error is an Internal OLE Automation error
Number: -2147217913 (0x80040E07)

by cdiaz

Here is the SQL script I am using to search on the text field.

SELECT * FROM "Form_Table Query1" WHERE (Form_Title LIKE '%::Form_Title::%')

This discussion is closed to new replies.