Network connection may be lost error 3

[JohnLanc]

I have a split database consisting of a front and back end both located in the same network directory.

One button on a form in the database keeps generating the following message:

"Error accessing file: Network connection may be lost"

This buttons function is to load a form which is also in the front end. The network connection cannot be lost as all other actions still function.

Does anyone have any ideas?

Thanks
John

 

[BuGlen]

Is the form bound to a linked table? If so, is the linked table in the same backend db as the other tables, or are there links to other data sources?

Check the properties of the form and make sure the datasource is still available.

Hope this helps.

- Glen

Know thy data.

 

[Hap007]

John,

I have seen this error at two times.

The first is when the network connection is truly lost or renamed. You can correct this using Tools>DatabaseUtilities>Link Table Manager and refresh links/location.

The second case is a little misleading. Here is the scenario.
If you copy a form, report or code module or you import the same or if you rename any of these modules, the next step is to compile the source code.

If you fail to do this, Access may get confused and the source code becomes unusable. If this happens, access thinks it can not find the source code for the form and then becomes corrupt and gives you the 'Network' error message.

Try This:
1) Open a form or report in design view
2) Open up the code window
3) Select Debug>Compile Database
4) If it compiles, then this is probably not your problem
but, if it can not open and compile all modules, then you have a code problem.

Hope This Helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[evalesthy]

see thread705-736614

 

[JohnLanc]

Thanks Guys that was helpful. It is an easy trap to fall into!

 

[Checking]

Indeed 'Hap007'; had an identical problem where I didn't get and found the answer to. Access continued giving the same error message: "Error accessing file: Network connection may be lost". It always occured when moving or copying forms from a test DB to production and without compiling database. Thumbs up for yr valuable info Hap !!