Discussion Locked

Bug in Access 2000 searching OLE documen

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This may be more of a developer/application question than a NetAdmin question, but I'm not getting any responses elsewhere. If nothing else, I'd appreciate someone confirming that they can or can't relicate my problem.

I am having problems in Access 2000 searching for text in OLE-linked Word documents.

Basically, the problem I am having is with a feature that worked in Access 97, but fails in Access 2000. Here are steps which work in Access 97:

1. Create a new database

2. Create a new table with two fields - an AutoNumber key field (I called it ID) and an OLE Object (I called it TEXT)

3. Populate the first record by switching to Datasheet view, selecting TEXT, then choosing Insert|Object and creating a new Microsoft Word document. Type in some text (I typed in "runcible spoon"). Save the table (as table1).

4. Create a new query like: select * from table1 where text like "*runcible*"

5. Run the query. Access 97 gives me the record I created in Step 3.

If I:- Save the database in Access 97 and open in Access 2000;
- Save the database in Access 97, convert to Access 2000, then open; or
- Start from scratch in Access 2000, then repeat steps 1-5,

I get an empty query result, which is not right. I'd appreciate confirmation that this is a problem for other users, as well as any ideas on how to work around it (our real-life application searches the text of several hundred OLE-linked files). I have Microsoft Access 2000 (9.0.2720) running on WindowsNT 4.0 with SP5.

5 replies

by pokester45

I recreated the database as you stated and I also received an empty query result. I am running Access 2000 with SR 1a on Windows Me.

This discussion is closed to new replies.