Access Runtime Error -2147467259 (80004005) VBA

  • Thread starter Thread starter Joseph Ladouceur
  • Start date Start date
J

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
 
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?
 
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
 
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
 
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
 
Ok, the error comes up when they click on the access
button which is a simple open object type command button.
They receive the same error if they go out to their C: and
try to open the exe file so I believe it has something to
do with the VB exe itself.

the error is exactly as it appeared in my earlier email
but I've listed it below again.

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.
 
Joe, I really can't offer any suggestions unless I see the actual line of
code that is causing the error; and preferably, the dozen or so lines of
code before & after it also.

Cheers,
TC
 
Depending on what your code is, this path may be too long (it's 72
characters). Some commands are limited to 64 characters for a path length.
Try putting the file in a location with a shorter path and then test your
code again.
 
have you tried to map your network drive to that folder where your vb.exe file is situated, that would make your directory shorter.

i'm also getting this runtime error, it has the same codes but the description of the problem is deifferent, mine says: the cascading options for the new reference conflict with existing reference '{EDB11581 - E76B - 4A34 - A549 - 5599AB600D70}'

I'm working on a program called odyssey, it uses acces files for it's data bases, normally a compact and repair fixes the runtime errors but not this time. i don't know what to do, i went through all the data but can't find the problem, the error only happens when i try to change a stock code, i have tha tutility inside the program, but it's not doing what it should, just giving the error and kicking me out of the problem.

PPPPLLLLLEEEEAAASSSEEE help.
 
Last edited:
Run-time error '2147467259(80004005)' Disk or network error

Hi,

I have created a VBA application that is being used in diferrent locations of our bussines using Access as back-end. SOme usres often get "Run-time error '2147467259(80004005)' Disk or network error" while saving data. Although it opens from my system quite well. Surprisingly the error stops after a while for all useres. I have browsed through different posts but nothing seemd directly connected to the issue I'm facing. I'm pretty new to the world of VBA/Access. Hope anyone could throw some light on it. Thanks
 
Last edited:
Back
Top