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.
