Error!!!

[aziz rasul]

Access 2000.

I have an opening switchboard form. On this form, I have a serious of command buttons that simply open other forms. Everything was working fine for many days without any change to the forms.

When I now press a command button on the switchboard form, I get the following error: -

"Error accessing file. Network connection may have been lost."

The db is on my hard drive and not on a network. Some files may be on a network? This I'm not sure about.

When I press the Help button on the dialog box, I get a blank screen.

 

[Robert Dunstan]

OK assuming that your database is on your hard drive as you say, could there be some code that is trying to open a file on the network?

I'm referring to the path name being hard coded and that the target file has been moved or is no longer available on the specified network drive / folder.

 

[aziz rasul]

The only code that I have is very simple stuff. No imports\exports are being performed anywhere. No Print commands are being used. The forms that I open simply have list\combo boxes. There are no linked tables either.

 

[neileg]

Sure you haven't linked an image, like a company logo or something similar.

 

[aziz rasul]

No.

 

[Rich]

Have you compilled and saved all modules, compacted the db, tried importing every thing into a new blank db?

 

[aziz rasul]

Yes. But no luck.

 

[Rich]

Try searching here for
Error accessing file. Network connection may have been lost, there have been a few posts on the subject, other than that try the MSKnowledgeBase

 

[aziz rasul]

I have solved the problem by simply recreating the form as everything that I tried didn't work.

I have never had this problem in Access 97. Hence this may be a 2000 problem.

 

[JimAhl]

I have had this problem happen to me many times

But I found the cause and a way around it.

It can happen one of two ways.

If you copy and paste a form or report that has any code behind it, or if you import a report or form that has code behind it.

Then you exit the DB and open it again, and attempt to run the copied or imported code, it fails and gives the error message. Not only that, once that initial code fails, none of your code can be executed, and it seems to disappear from the VB editor. This is a bug only in Access 2000.

There is no way to fix the database, once it happens, but there is a patch you can get from MS, but it is easy to avoid without the patch.

Once you have copied or imported the form or report, simply go into your code and compile it before you exit the DB. I have tested this a few times. I was able to recreate the error easily, and as long as I compiled before exiting, it worked fine.

Hope this helps.

Jim

 

[pono1]

Was stung yesterday.

Another Access 2000 Bug

Regards,
Tim

 

[moteq]

Same Problem

Same Problem. Phooey!

But, on a better note, this thread was very helpful in pointing me in the right direction...

I tested out a backup from two days ago, and it seems to be ok. I've moved my newer data there, and recreated the reports. Since I didn't copy them over from another db this time, I'm hoping everything will be ok. I'd rather not have to deal with creating new modules. I'm crossing my fingers.