Text search in linked ole object

[Ken]

I have an Access97 database with a field that has a linked OLE object
(Word document). I was using a query with the criteria expression
"Like[Use this format *keyword*]" on that field and it was working
fine.

After I converted this database to Access 2002, this query no longer
works. All I get is an empty table after running the query.

There are other queries in the database using similar wording and they
still work fine with the difference being they are not querying a
linked object.

Is there something I need to do differently or am I just out of luck
with Access 2002?

Thanks

 

[Douglas J. Steele]

If you're using ADO to run your queries, use % as the wildcard instead of *.

 

[Ken]

I have tried using %, the results are the same. I
thought access stored and image of the linked file and
this could be searched, but it seems like its not there.

-----Original Message-----
If you're using ADO to run your queries, use % as the wildcard instead of *.

--
Doug Steele, Microsoft Access MVP

I have an Access97 database with a field that has a linked OLE object
(Word document). I was using a query with the criteria expression
"Like[Use this format *keyword*]" on that field and it was working
fine.

After I converted this database to Access 2002, this query no longer
works. All I get is an empty table after running the query.

There are other queries in the database using similar wording and they
still work fine with the difference being they are not querying a
linked object.

Is there something I need to do differently or am I just out of luck
with Access 2002?

Thanks

.

 

[Chris Mills]

Sometimes you need to use Trim(keyword) where you didn't in A97.