Access Runtime Error -2147467259 (80004005) VBA

[Joseph Ladouceur]

I've created an Access Database for my department. On my
switchboard manager I've set up a command button to open a
VB 6 .exe that I created. Now when I click the command
button it loads the VB program without a problem, I have
VB 6 on my computer though. Now on 2 workstations I've
gotten the error
"Run-time error '-2147467259 (80004005)'

'S:\COMMON\FINANCE\FINANCE\PUBLIC\PRODUCTION\2004
\JVS\DATABASE\Finance.mdb' is not a valid path. Make sure
that the path name is spelled correctly and that you are
connected to the server on which the file resides."

Now the VB program the command button is opening is
installed on the users C: drive so they're obviously
connected and the path is correct because it's the same on
all PC's and it works on several other workstations. How
can I fix this? I've seen several posts with the same
error but none of them were really closely related to my
problem and the solutions weren't very helpful. I had a
similar problem on several other computers where I just
needed to preform the following steps I found on another
website.

open CMD prompt
type cd/d "%CommonProgramFiles%\System\Ole DB"
type regsvr32 oledb32.dll
type regsvr32 oledb32r.dll

however that has not solved the problems on these two
computers. Any help is greatly appreciated. Please Email
me at (e-mail address removed) as this is my
first time on the boards here and not sure if I'll be able
to get back here lol.

Thanks again

 

[Ken Snell]

A completely wild, uninformed guess...I note that you have FINANCE twice as
a folder name in the path...any chance that one of them is extraneous?

 

[TC]

No-one will email you privately. The reason that people contribute their
time to these message boards, free of charge, is so that everyone can
benefit from the answers provided. The boards are not a private, free
consulting service.

I notice lots of entries for that error number in google groups. Maybe some
of those would help.

HTH,
TC

 

[Guest]

No that is the correct file directory. And I did look
this up on Google and found lots of entries however very
few of them delt with Access and most of them had to do
with printer connection problems and not with the type of
problem I'm having here.

Thanks for helping though it's appreciated

Joe

 

[TC]

Does the error come directly from the code for the command button? (If so,
show us that code.) Or does it come from the VB program that is started by
the command button? (If so, show us >that< code!)

TC