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
--
Roy-Vidar
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?
--
Roy-Vidar
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 ;-)
--
Roy-Vidar
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
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
They found a solution, and posted it here (watch for linebreaks)
http://groups.google.com/group/microsoft.public.access.modulesdaovba/msg/5dcf7c9fd54454e9
--
Roy-Vidar