Can't insert OLE documents in Access 2007

N

nathan.hunstad

I know that several other people have had this problem, but I have yet
to find a solution. The situation is this: upgrading from Office 2000
to Office 2007. Our Access database has some OLE fields with which we
use to stored mainly DOC/PDF files. When I open the database in Access
2007, I can't attach any documents of any type to the OLE field. I get
an error message of "OLE Server Not Registered". This happens for all
file types.

Did a complete uninstall and reinstall, no change. Converted the
database to Access 2007 format, no change. Did the Triedit.dll
registration trick, no change. I'm running out of ideas to try! Any
advice on how to get OLE working?
 
N

Nathan

Here is some additional information...

Windows XP Professional SP3
Office 2007 SP1 with all other updates installed
When I hit CTRL+SHIFT+I when the error message pops up, the number in
the lower right corner is 502750
Running Symantec AV 2004, but even after uninstalling there was no
change (reference to http://support.microsoft.com/kb/295824/en-us)
 
N

Nathan

I have found the source of this bug. After going through the Windows
Debugger and logging all Access API calls, I determined that for some
reason, ole32.dll searches for a registry key called HKEY_LOCAL_MACHINE
\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility
\{00000000-0000-0000-0000-000000000000}. If this key does not exist,
then things continue normally and eventually the file will be
attached. If this key does exist, however, Access will give the error
message. Deleting that key solves the problem, and attachments can be
made.

Upon further research, is appears that Spybot: Search and Destroy
(among other programs) puts this key in there. I am curious as to why
Office 2007 uses this key when previous versions of Office did not. In
any case, if anybody from Microsoft is monitor these forums, this may
be something to add to your Knowledgebase, as I'm not the only person
who has had this problem. I have the logs of the API calls if
necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top