We help IT Professionals succeed at work.

Currentproject.Connection Problem

wolfjjj
wolfjjj asked
on
Medium Priority
784 Views
Last Modified: 2007-12-19
Got a problem here we can't work out. When trying to access Currentproject.Connection it bombs out
ie ?Currentproject.Connection in the debug window it brings up the following error

Error: -2147024714(800700B6)
The operating system cannot run %1

It has worked fine up until yesterday, I'm assuming it's something to do with one of the DLLs somewhere, I've tried reinstalling ADO, Repairing Office and cursing and swearing a lot.
Comment
Watch Question

Commented:
The %1 could point to a missing parameter or a field that's no longer "known"
On the other hand I would first check manually or the target of the connection is reachable, as with the minda virus a lot of servers have been "closed"...

Nic;o)

Author

Commented:
It's just an access database, one of the apps that uses it connects to our sql server but the other is just local so that cant really be it.

Commented:
Did you also try to increase the Timeout from the default 60 to e.g. 600 ?

Nic;o)

Author

Commented:
Even if you create a blank empty database, open the debug window and type ?currentproject.connection it comes up with the error and it's only on that computer
Commented:
Then I'm stunned...
The ?Currentproject.Connection works OK for me, so it's hard to guess what can be wrong.
Did you check your installed jet-engine and applied the last patches?
SR1a:
http://support.microsoft.com/support/kb/articles/Q245/0/21.ASP

Nic;o)
wolf

thats because its a connection object.

as in an ADO connection object.

you would have to say currentProject.connection.connectionstring in order to see anything at the ??

it goes without saying that I am now having an identical problem...

Aaron

Commented:
Has anyone figured out what this is all about. I am having this issue with a client of mine.

Commented:
Hmm, old closed Q...

In the meantime a new SR has been released, check:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q276367

When still trouble, then post a new Q.

Nic;o)