General discussion

Locked

Bug in Access 2000 searching OLE documen

By tad ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Bug in Access 2000 searching OLE documen

by pokester45 In reply to Bug in Access 2000 search ...

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.

Collapse -

Bug in Access 2000 searching OLE documen

by tad In reply to Bug in Access 2000 search ...

The question was auto-closed by TechRepublic

Collapse -

Bug in Access 2000 searching OLE documen

by James_Randy In reply to Bug in Access 2000 search ...

Re-format. Re-load & start all over again.

Collapse -

Bug in Access 2000 searching OLE documen

by tad In reply to Bug in Access 2000 search ...

The question was auto-closed by TechRepublic

Collapse -

Bug in Access 2000 searching OLE documen

by tad In reply to Bug in Access 2000 search ...

This question was auto closed due to inactivity

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums