Error accessing file. Network connection may have been lost.

Hi all,

I'm developing Access apps using Access 2000 on a Win2Kpro machine with the web server enabled AND Visio 2002 installed. I've installed SP3 per Microsoft instructions per KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;304548

However, I'm continuing to get these darned errors with my VBA modules. Anyone know of any other preventative methods other than the ones mentioned in the KB article?

My databases are recoverable, except for the offending form but this is becoming a huge impediment to my development. Anyone with any ideas other than installing Win2K pro on another partition and using that boot to develop database front-ends with? I switch between Access2k, Visio, VB.NET, C++.net and Sun Java Studio all day.

Thanks in advance.
LVL 3
fcfangAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

heer2351Commented:
You can try the following undocumented command line option. Make a copy of your database first !

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"  complete_path_to_your_database.mdb /DECOMPILE

Note: you get no indication at all that access did the decompile.

Now compile all modules again and see if this solves it.
0
jadedataMS Access Systems CreatorCommented:
If you are doing that development OVER the network with the faulty connections,... stop before you pull all you hair out.
Do your development on the client side and then replace the production db with the dev copy.
0
fcfangAuthor Commented:
Thanks for the quick replies guys.

Jadedata:
All development is done on the local machine. The only thing off of the local machine is the link to the ODBC data on a SQL server. However, this is not the cause of the problems.

Heer23351:
I tried the decompile and although it doesn't work for me (the module for the form appears completely blank), the db is recoverable. It's just that I reuse a lot of my modules from app to app and I don't always remember to recompile the db before closing the mdb, hence my dilema with the corruption. My question's more about prevention. Thx tho.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

heer2351Commented:
Here is a link to the corrupt mdb faq from Tony Toews, check to see if it has any value for you:

http://www.granite.ab.ca/access/corruptmdbs.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jadedataMS Access Systems CreatorCommented:
prevention:
  CRBCRBCRBD

 CRB = Compile Repair Backup
 D = Decompile

I even have built a routine that will copy out all the coded objects in the app to a separate mdb for storage and backup.
0
fcfangAuthor Commented:
Thanks again for the quick responses. I had been hoping for some answer like "Oh, there's a new vbe6.dll that'll fix this problem..." but alas I'll have to settle for building a little device to deliver a little electric shock each time I import a form or module to remind me to compile the db.

I'm considering a move to Access 2002 for development as it appears not to have this problem.

Thanks once again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.