We help IT Professionals succeed at work.
Get Started

ActiveX/OLE in ADP

rsoble
rsoble asked
on
2,823 Views
Last Modified: 2013-12-05
I am converting an old .mdb to a new .adp.  I have OLE Automation turned on and have been successfully using the ActiveX Calendar on several forms.    Actually I'm not sure it's OLE or ActiveX - in properties it lists as OLE Class Calendar, MSCAL.Calendar.7.  It came from the original .mdb and anyway, it works fine.  I tried adding an ActiveX List View object to a form (trying to get better searchability from my list without adding a lot of extra coding) and when I open the form I get the following error:

"The operation on the OLE server failed.  The OLE server may not be registered.  To register the OLE server, reinstall it."

I went into the Module|Tools|References and toggled the OLE automation on and off (toggle off, close/open Access, toggle on, close/open Access) with no effect.  I did the same thing with the Microsoft ActiveX Data Objects 2.1 Library with no effect.  I also had other versions of this Library (up to 2.7) so I tried a couple of those and finally ended with the 2.7 installed.  (someone tell me why there are so many?  backwards compatibility?  and which should I be using?   anyway back to the real question....)

I checked the path to the ActiveX object (C:\Program Files\Microsoft Office\Office11\FPDTC.dll) and the file is there.  I thought I could unregister and then reregister the object through Tools|ActiveXControls, but when I try to unregister I get the error "[Path\File] was unable to add/remove itself to/from your system.  Install/remove the control using a separate setup utility".  As usual for Microsoft, the answer is very clear but also very useless, since it doesn't tell me what separate setup utility I should be using.

I checked in my running services and didn't see an OLE server running.  Is it really a service or just a file?
Any ideas how I get this ActiveX List View object to work?  I would think that since it's one of the standard ones included that it should be pretty simple.  

I'm using Access 2003 on Win XP.
Thank you.
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2006
Commented:
This problem has been solved!
Unlock 2 Answers and 16 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE