Very mysterious Access 2k Error: Disk or Network Error

T

Tony

I recently encountered a really awkward error.

I have a multiuser access2k (frontend/backend) database
setup backend - tables, frontend - everything else. It
uses a workgroup file and have the users assigned to
various groups with various permissions.

The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...

i have to exit and go back into the database to see the
tables and queries again..

has anyone had this problem and if so how did you fix it?

I already tried the following steps.

1) Compacted and Repair both frontend + backend MDB files
2) Made sure user is has the Office 2000 sp3 update
3) I am having problems recompiling the frontend database.
It was suggested to me that the frontend database needs to
be recompile after you import objects into it. There is no
code in any of the forms, no macros, and no modules.
However, as suggested, I wanted to recompile it. I went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."

I'm fairly certain that the network connection is there...
because I can access other MDB files on the server.

Has anyone encounter this problem before? If so what
resolutions did you try?


Much Thanks and Appreciation, Tony
 
P

Paul Overway

Access is hypersensitive to network issues and the error you have
encountered is common with a network isssue. The problem could be related
to a bad NIC, port on a hub/switch, routing issue, etc.. The solution is
to resolve the issue on the network.
 
D

Dirk Goldgar

Tony said:
I recently encountered a really awkward error.

I have a multiuser access2k (frontend/backend) database
setup backend - tables, frontend - everything else. It
uses a workgroup file and have the users assigned to
various groups with various permissions.

The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...

i have to exit and go back into the database to see the
tables and queries again..

has anyone had this problem and if so how did you fix it?

I already tried the following steps.

1) Compacted and Repair both frontend + backend MDB files
2) Made sure user is has the Office 2000 sp3 update
3) I am having problems recompiling the frontend database.
It was suggested to me that the frontend database needs to
be recompile after you import objects into it. There is no
code in any of the forms, no macros, and no modules.
However, as suggested, I wanted to recompile it. I went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."

I'm fairly certain that the network connection is there...
because I can access other MDB files on the server.

Has anyone encounter this problem before? If so what
resolutions did you try?


Much Thanks and Appreciation, Tony

It sounds to me like you may have been bitten by a very nasty bug in
Access 2000. See if this KB article describes your situation.

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

If so, Office 2000 SP3 fixes the bug, but that won't repair your
corrupted database. You'll have to resort to a backup, or else try
importing all objects to a new database -- some objects probably won't
import, and you'll have to recreate them from scratch. When you do
import the objects, unless you've applied the service pack, it is
*crucial* that you compile and save the project before closing the
database.
 
T

Tony

Thanks Paul, I talked to our network guys and they concur.
We're addressing the issue on 2 fronts.

1) I'm rebuilidng the database, importing the old forms
and reports from a previous backup, and then recompiling
it.

2) the network guys are going to bump up the port from
that user's machine from 10 Mbps to 100Mbps and also going
to add a 3rd NIC card to the file server that host the MDB
file to boost the bandwidth.

fingers crossed, bitting lips... and praying.

Thanks for your help again,
Tony
 
T

Tony

Thanks Dirk, I talked to our network guys and they concur.
We're addressing the issue on 2 fronts.

1) I'm rebuilidng the database, importing the old forms
and reports from a previous backup, and then recompiling
it.

2) the network guys are going to bump up the port from
that user's machine from 10 Mbps to 100Mbps and also going
to add a 3rd NIC card to the file server that host the MDB
file to boost the bandwidth.

fingers crossed, bitting lips... and praying.

Thanks for your help again,
Tony
-----Original Message-----
I recently encountered a really awkward error.

I have a multiuser access2k (frontend/backend) database
setup backend - tables, frontend - everything else. It
uses a workgroup file and have the users assigned to
various groups with various permissions.

The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...

i have to exit and go back into the database to see the
tables and queries again..

has anyone had this problem and if so how did you fix it?

I already tried the following steps.

1) Compacted and Repair both frontend + backend MDB files
2) Made sure user is has the Office 2000 sp3 update
3) I am having problems recompiling the frontend database.
It was suggested to me that the frontend database needs to
be recompile after you import objects into it. There is no
code in any of the forms, no macros, and no modules.
However, as suggested, I wanted to recompile it. I went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."

I'm fairly certain that the network connection is there...
because I can access other MDB files on the server.

Has anyone encounter this problem before? If so what
resolutions did you try?


Much Thanks and Appreciation, Tony

It sounds to me like you may have been bitten by a very nasty bug in
Access 2000. See if this KB article describes your situation.
[LN];304548

If so, Office 2000 SP3 fixes the bug, but that won't repair your
corrupted database. You'll have to resort to a backup, or else try
importing all objects to a new database -- some objects probably won't
import, and you'll have to recreate them from scratch. When you do
import the objects, unless you've applied the service pack, it is
*crucial* that you compile and save the project before closing the
database.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
 
T

Tony Toews

Tony said:
The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...

This behaviour sounds about right for a "disk or network error". My
experience has been that these are caused by hardware problems. In my
particular case I had a laptop network card dongle in which one
network cable didn't seem to seat properly.

But there could be many other reasons for this. See the Access
Corruptions Causes MDB at my website for some.
went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."

This is a separate problem which Dirk has already given you the
answer.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top