error accessing file. Network connection may have been lost

[saleem]

i created a front end in access keeping database on sql server and using ODBC for connection..but the front end has started giving following messages whenever i try to open anything...

"Microsoft Visual Basic

Error accessing file. Network connection may have been lost "

can anyone help me out getting rid of this error

saleem

 

[DTurrall]

Hi Saleem.

As I'm sure you've noticed, I'm having a similar problem.

I far from understand the problem, but the database seems to end up in a state where all modules (including those within forms) refuse to run any code.

I have NOT managed to fix the problem by compacting and repairing the database, or by deleting the offending module (or form / report etc) and recreating it.

The only way I have managed to restore a database in this state is to create a new database, import all of the objects that do not contain modules, and then copy+paste the contents of all other objects into new objects in the new database, e.g. for a form - copy all of the controls, copy all underlying code, set all event properties of controls on the form again so that it 'works'. Or just import the objects from that backup you made...

Good luck.
David

 

[saleem]

Thanks DTurrall

I too have reached this hard, long and teasing solution after a applying and trying each and evert thing...but this problem should have been addressed to Microsoft..

anyway thanks again