By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Text search in linked OLE object

P: n/a
Ken
I made an Access97 database that had a field with 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.

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

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
One possibility would be to check and see what is the SQL syntax being used.
To do this on the menu bar go to Tools, Options, select the Tables/Queries
tab and see if the "SQL Server Compatible Syntax(ANSI 92)" is turned on. If
it is turn it off and see if the query starts to work. When I program using
ADO objects (which use the ANSI 92 syntax I believe) I have to use '%' in
place of '*' as a wild card. An alternative would be to swap wild cards and
see if that works, but that is a poor choice, because many applications have
more than one query with wild cards.

--
Jeffrey R. Bailey
"Ken" <ke******@wcnet.net> wrote in message
news:ba*************************@posting.google.co m...
I made an Access97 database that had a field with 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.

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

Thanks

Nov 12 '05 #2

P: n/a

That was not the problem. "SQL Server Compatible Syntax(ANSI 92)" was
not selected (I tried selecting it, but that didn't work either). I
also tried changing the * to %, but that didn't work. This database has
2 other queries that are written the same way, and they still work.
The only difference is that they are querying a regular field, not one
with a linked OLE object. That seems to be the key, but it is beyond my
knowledge level.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.