Error msg: Error accessing file... 1

[robmkimmons]

I have done something in my database and now anytime i try to access records from forms i get this error:
"error accessing file. Network connection may have been lost"

I can go into the tables and edit/add information, but i just can't do it in forms.

Any suggestions as to why?

~Rob

If we expect the unexpected, does that make the unexpected... well, expected?

 

[JeremyNYC]

What's the recordsource of your form? Does this go away after a reboot?

---
Jeremy Wallace
Up & Running Project Coordinator
Fund for the City of New York

 

[RoyVidar]

You haven't said whether this db is on a network or not. If it isn't, then I'd guess corruption. If it is, then I'd still guess corruption might be the cause, by the symptoms you describe.

This faq Corrupt Microsoft Access MDBs FAQ has a lot of info concerning corruption, symptoms and how to deal with it. (I think, following the link "some corruption symptoms", you'll find description of it) MakeItSo's FAQ705-4683 also has some recommandations.

During the last years, I've resolved all my corruption issues using the /decompile option, in stead of importing objects. It's described here Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times

Here's also an option that might provide some results on exporting/importing database objects Thread705-834817.

Roy-Vidar