Error 2147024769

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



One installation out of hundreds returned this error and was unable to
open the switchboard form, reporting

Error -2147024769
Method 'Connection' of object 'CurrentProject' failed.

offending code is:

Set Conn = Application.CurrentProject.Connection

Search of google indicates this is a rare error that many vendors have
had single occurances of and virtually no reports of fixing it.
Microsoft KB306132 addresses this issue. The reported fix is to load
the current MDAC file. Unfortunately, if you have XPSP2, you cannot do
this directly. Microsoft has a downloadable tool to check your MDAC
level, and for our single problem workstation it reported MDAC 2.7 SP1
instead of 2.8 SP1.

TOOL:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=NHX676C

The answer was to reload XP SP2, since MDAC 2.8SP1 is not seperately
installable for XP

Here's hoping this helps some poor support tech with this obscure error
in the future!

.



Relevant Pages

  • Re: Automatic updates in continuous loop
    ... Requests for assistance by email can not and will not be acknowledged. ... Installed SP1. ... > Automatic Updates is in a continuous loop, reporting that SP1 is downloaded ... After successful installation is ...
    (microsoft.public.officeupdate)
  • Re: No OLE DB providers listed when creating a Linked Server
    ... offender in other cases as well. ... An additional note; reinstalling mdac 2.8 ... >> I've seen others reporting the problem when upgrading to Win 2003. ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Manger Installation & MDAC 2.8
    ... Uns war nicht bekannt dass es einen neuen MDAC Treiber ... > Christian Koller schrieb ... ... >> wir haben ein Problem bei der Installation der SQL Clienttools ... > Installiere die MDAC 2.8 SP1 vor ab, ...
    (microsoft.public.de.sqlserver)
  • RE: Snap-in creation failed
    ... I understand that after install the SP1, you cannot open the Monitoring and ... Reporting on the Server Management. ... Did you follow any instructions to install the SP1? ...
    (microsoft.public.windows.server.sbs)
  • Re: SMS Reporting hell
    ... install of the Reporting Point rather than having Site ... >The IIS installation is in the default location and I ... >The account I log onto the server with has the same ...
    (microsoft.public.sms.admin)