Previous Thread

8/2/2006 9:43:02 AM    run-time error '-2147467259 (80004005)': could not find file
Win2003, XP Pro, Access 2003 
 
Creating an Access app for a client.  Installed a prototype of 1st module on 
 
client's machine about two to three weeks ago.  Every thing is fine. 
 
Was adding some additional functionality today and when I try to open the 
 
database I get the error that says it cannot find the file.  Nothing has 
 
changed, same path, same file name.  Happens on new code as well as old code. 
 
New code is a copy of old code! 
 
Here is the code: 
 
cnObject.Open "provider = microsoft.jet.oledb.4.0; " & _ 
 
"data source = 
 
J:\Clients\Pang\DevDatabase\CertificationTraining.mdb; " 
 
This worked a few weeks ago!  Let me repeat, nothing has changed on my box. 
 
It is not shared with anyone.  Well almost nothing, my company has the auto 
 
updates turned on, have no way to stop them. 
 
Any ideas would be sooooo appreciated. 
 
Thanks a bunch for taking the time to read my post and thinking about my 
 
dilemma. 
 
Jim



8/2/2006 2:51:09 PM    Re: run-time error '-2147467259 (80004005)': could not find file
First, verify manually that J:\Clients...etc., is actually valid.  Maybe you 
 
lost the network connection at some point?  You can also try copying the 
 
file to something local and changing the path just to test it out. 
 
The second thing to try is to decompile your code (launch Access with the 
 
/decompile switch; Google it or ask if you need more specifics on that). 
 
Final thing (that I can think of off-hand, anyway) is to just double-check 
 
that the Jet OLEDB provider is properly installed.  It's REALLY unlikely 
 
that it's been uninstalled, but with computers being what they are, just 
 
about anything's possible! :) 
 
Rob 
 
"CrystalJim" <CrystalJim@discussions.microsoft.com> wrote in message 
 
news:CE334AB8-B113-4BF9-8D6C-7EEE9279DA6B@microsoft.com...