Searching/querying text in OLE object field of Access table

  • Thread starter Thread starter Nam
  • Start date Start date
N

Nam

I have stored large text files in an OLE object field of a MS Access 2003
table. But when I try to query this field using the following in the search
criteria of MS Access query, it does not return any results even if the
parameter SearchText is passed a value that I know is contained in the stored
text files. Whereas if I use the same search criteria on other text columns
of the table, the query returns the expected results:

Like "*" & [SearchText] & "*"

What I am doing wrong? Is there any other way of achieving the same, such as
using ADO in VBA or VB6?

Thanks.
 
Hi,
you can't query OLE fields like this. You can only extract it content to the
file or string variable and then search there.
I think you can make a subtable with your texts stored in several memo
fields, cut by 64k, and then search there.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top