CurrentProject.Connection failure

[alex_hatzisavas]

Hi all.

I'm having a serious problem when i'm trying to use the CurrentProject.Connection property for some ADO manipulation.

Here's the error message i'm getting:

Run-time error '-2147220999 (800401f9)':
Method 'Connection' of object '_CurrentProject' failed

In the immediate window, i try to execute this statement:

Msgbox CurrentProject.Connection

but again i get a funky error with the same error code as above:

Automation error
Error in the DLL

I got this error working on two different machines, both running Windows XP.

Any help will be greatly appreciated.
Alex

 

[boblarson]

Which version of Access are you using?

 

[alex_hatzisavas]

MS Access 2002 (10.6501.6626) SP3

 

[boblarson]

You probably have, but have you checked the references to make sure that there are none "MISSING?"

 

[alex_hatzisavas]

No references are missing, i'm using Microsoft ActiveX Data Objects 2.1 Library for ADO.

 

[boblarson]

Well, hopefully someone else has some ideas as the code works for me and I'm running out of ideas.

Is the OLE Automation reference checked too?

 

[alex_hatzisavas]

Yes, ADO and OLE references are checked.

This must be a corruption of some DLL issue i guess.

Would removing and reinstalling Access work?

There are some MDAC patches that one can download from the MSDN website, but they don't work either.