CurrentProject.Connection failure

[Guest]

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

 

[RoyVidar]

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

Have you checked this (watch for linebreaks)?
http://support.microsoft.com/default.aspx?scid=kb;en-us;306132&Product=acc

 

[Guest]

Hi Roy, and thanks for the reply.

I tried to download various versions of the MDAC software (2.8, 2.7 etc.),
but i was told that the features of those programs are now included into
Windows (i'm running Windows XP).
So the installation wasn't completed.

 

[RoyVidar]

Hi Roy, and thanks for the reply.

I tried to download various versions of the MDAC software (2.8, 2.7
etc.), but i was told that the features of those programs are now
included into Windows (i'm running Windows XP).
So the installation wasn't completed.

The error indicates the DLL is bad/corrupted, and if you can't
reinstall
it, then I don't know what to suggest, I'm afraid.

Hopefully others can contribute.

Does changing ADO version make any difference?

 

[Guest]

No, changing ADO version didn't help.

Would removing and reinstalling Access help?

 

[RoyVidar]

No, changing ADO version didn't help.

Would removing and reinstalling Access help?


:

I'm afraid I don't dare making any suggestion, as I don't know. There
is
something wrong somewhere, but I don't know where. Some random thoughts
below.

I was thinking that on my computer with WinXP without SP2, I was
allowed
to install MDAC 2.8, but on a computer with SP2, I wasn't (same message
as you reported). So, if that is correct, and if this is an MDAC
issue???

Is this isolated to one or a few computers? Does it only happen in this
db, or also dbs? Would using

currentproject.accessconnection

make any difference? Or

codeproject.connection
codeproject.accessconnection

So, I'm hoping someone else has something to offer, but I don't think
a reinstall will hurt, it just takes time ;-)

 

[Guest]

Roy, thanks very much.

I tried installing MDAC 2.7 RTM (the only one that would be installed on my
machine), but it didn't work.

The alternative statements that you specified also generated 'automation' or
'dll' errors.

I think i'll just reinstall the product and hope to solve this

Alex

 

[Guest]

Did the re-install work?

I got a compile error on currentproject.connection saying invalid or bad dll.

I re-installed a couple weeks ago and it seemed to work.. I change the
Access app today but get this compile error again. So I am not sure.

Thanks
--


Fantastically,

Alan Ayers

 

[RoyVidar]

Did the re-install work?

I got a compile error on currentproject.connection saying invalid or
bad dll.

I re-installed a couple weeks ago and it seemed to work.. I change
the Access app today but get this compile error again. So I am not
sure.

They found a solution, and posted it here (watch for linebreaks)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/msg/5dcf7c9fd54454e9