Searching/querying text in OLE object field of Access table

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.
 
A

Alex Dybenko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving large text files from OLE object filed of a MS Access 2 2
unbound OLE PDF Object in Access Report doesn't update 1
Access Dcount (multiple criteria) 3
Searching text in an OLE-Object (Word) 2
Opening OLE Object Sync Issue within VBA Code 0
Open OLE from Access 3
code in VB for sending emails to the field values in a table 2
OLE Object Data Type Question 8

Top