Visual Basic Error

  • Thread starter Thread starter John
  • Start date Start date
J

John

When i open a data entry form and click add entry button i
have created i get a pop up error that says,

Error accessing file. Network Connection May have been
lost.


the button was working an hour ago, and now i get this.
anyone have any ideas what it could be?
 
John,

Is your system on the network? Is the backend db on a
file server and the screens on the local PC? If so, your
PC might have been disconnected from the data source.

If however your screens and the data are in the same
database, I don't know why you would be getting such an
error offhand.

Ivan
 
I recently had this - apparently it can happen with Access 2000 if you do
not have SR3 installed.

Apparently it usually happens when you import an object into the database,
and it effectively corrupts the code in it.

The solution I had to use (as I did not have a recent enough back-up) was to
set copy the text from all the modules (including form and class modules),
then delete normal modules and set all forms to Has Module = No. Then copy
all the code back in again.

Not a lot of fun! There is more info on this on tech net - enter the text of
the error message and you should find it.

Paul
 
I have seen this twice with customers using a wireless network.

Is that your situation?

Michael
 
The laptop was on a wireless network, but the db was on a *local* drive.

The error message (in this case) is spurious - it has nothing to do with the
network connection, the problem is that the db is corrupted by importing
objects if you do not have the correct service pack installed.
 
Back
Top