(Msg. 1) Posted: Mon Jul 28, 2008 10:22 am
Post subject: Can't insert OLE documents in Access 2007 Archived from groups: microsoft>public>access>setupconfig, others (more info?)
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?
(Msg. 2) Posted: Mon Jul 28, 2008 1:46 pm
Post subject: Re: Can't insert OLE documents in Access 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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)
On Jul 28, 12:22 pm, nathan.huns....DeleteThis@gmail.com wrote:
> 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?
(Msg. 3) Posted: Thu Jul 31, 2008 8:57 am
Post subject: Re: Can't insert OLE documents in Access 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
On Jul 28, 3:46 pm, Nathan <nathan.huns... DeleteThis @gmail.com> wrote:
> 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 tohttp://support.microsoft.com/kb/295824/en-us)
>
> On Jul 28, 12:22 pm, nathan.huns... DeleteThis @gmail.com wrote:
>
> > 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?
(Msg. 4) Posted: Tue Oct 14, 2008 7:28 pm
Post subject: Re: Can't insert OLE documents in Access 2007 [Login to view extended thread Info.] Archived from groups: microsoft>public>access>forms, others (more info?)
I have this problem, am in the registry but cannot find this key. Any advice?
"Nathan" wrote:
> 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.
>
> On Jul 28, 3:46 pm, Nathan <nathan.huns....RemoveThis@gmail.com> wrote:
> > 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 tohttp://support.microsoft.com/kb/295824/en-us)
> >
> > On Jul 28, 12:22 pm, nathan.huns....RemoveThis@gmail.com wrote:
> >
> > > 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?
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum