Error accessing file, Network Connection may be lost

[Badger]

I have been devloping a database (Access 2000 )and saving it as NameV1, Name
V2 etc. everytime I make progress, but all my latest ones are getting error
network connection may be lost or error accessing file - network connection
may be lost. Recently I cant even open some of my forms they are locked
-unattainable. Tried Making New DB and importing all over but still getting
more and more errors. Have tried repair and compacting but doesnt appear to
do anything (or work!) Tried debug and looking at code but in VB modules
curser always seem to be at Option Compare Database. I dont understand VB and
am using access to learn about Access using wizards, Queries, macros and
recently tried functions but this seemed to accelerate problems. Extremely
frustrating after all the work I've put in. Ive heard people say Access was a
bit unpredictable but I only want to use it for a small club membership 1
user. I go back to last working copy and try re-putting things in but Im just
redoing work and then getting more errors.

 

[Badger]

Thanks in anticipation -Ill try that, best advice I've had yet -tried access
forums but not much luck, either people dont know or can't solve, so if it's
a service pack I need then that sounds more hopeful.

 

[Tom Wickerath]

If you do not already have Service Pack 3 already installed, then the chances
are virtually 100.00% that this is the cause of your problems. How's that for
a betting man's odds? <smile>

While you are at it, you should make sure that you have the latest update
for the JET database engine, and the latest service packs for your operation
system. You can find information here that shows you how to check for these
things:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528


Good Luck!

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Badger]

Have followed all links feel a bit happier now nowing it's not all completely
down to my ignorance. Still getting errors however I am trying to go back to
find a backup that wasn't corrupted. I now have so many all with different
bits affected. Going round in circles but if I cant resolve this Ive learnt a
very valuable lesson about the methods I used and if necessary I will go back
to just my tables and rebuild from there! All I hope now is that if I get as
far as macros and functions i will not end up with same probs in future., cos
thats where I seemed to really get into hot water.Thanks again will now
repost back to access forum where I originally started this thread.

 

[Tom Wickerath]

Hi Badger,

I forgot to mention that installing the service pack will not automatically
fix a corrupted project, although I believe the KB article states that pretty
clearly. It should, however, prevent any similar corruption from occuring.

Thanks again will now repost back to access forum where
I originally started this thread.

I'm curious.....which forum is that?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tony Toews]

-tried access
forums but not much luck, either people dont know or can't solve,

Just curious. What Access forums had you tried?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

Ran into the same "Error accessing file" problem

Due to many problems I had reformatted my hard drive and reintalled Windows
2000 and Office 2000 because that's the environment my principal client has.
I've upgraded Office 2000 with Service Pack 1A and then with Service Pack 3.
I'm still having the problem with Access databases that previously worked
okay displaying the message "Error accessing file. Network connections may
have been lost." This, despite the fact that the database is being used on a
local computer without any network connections.

Can anyone help me undestand this problem and help me solve it?

ACC2000: Error Message: Error Accessing File. Network Connection May
Have Been Lost. http://support.microsoft.com/?kbid=304548 is the
official KB article.

I see they have instructions that may get you back your MDB. But the
real problem is that once the MDB is corrupted with this error message
it's too late.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tom Wickerath]

Hi Gordon,

This, despite the fact that the database is being used on a
local computer without any network connections.

As far as I know, the error message has nothing to do with a connection to a
network. Why the error includes this text is a mystery to me. I would verify
that Service Pack 3 is correctly installed. You should see version 9.0.0.6620
for MSAccess.exe.
(Reference: http://www.access.qbuilt.com/html/fix_its.html#OfcVersion)

Also check the version of VBE6.dll. You don't want to see version 6.3.91.8.
Per KB 304548 (http://support.microsoft.com/?id=304548): "The version number
of Vbe6.dll may also appear as 6.03.9180, depending on the version of Windows
that you are using." Have you tried the resolution discussed in this KB
article?


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tony Toews]

I've read KB304548. It seems there's no convenient way to recover the
database that has the "Error accessing file" problem. I'll have to follow
the instructions in the Resolution section of KB304548. This will be very
time-consuming because my database has many forms and reports, most of which
are supported by VB code.

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corruption/corruptobjects.htm

The undocumented SaveAsText and LoadFromText may help if an object is
corrupted or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.datastrat.com/Code/DocDatabase.txt for
saving all objects in an MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm