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.