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
 

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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
unbound OLE PDF Object in Access Report doesn't update 1
Access Dcount (multiple criteria) 3
Emailing OLE Objects 1
Generic Search Capability Using Filters 7
Searching text in an OLE-Object (Word) 2
email attachmnet (OLE object) 1

Back
Top