Disk or Network Error

[Mateo]

We have an Access97 application running on an XP Pro
client with approximately 10 users. The application is
shared on a Windows2000 file server using Active
Directory. The workstations also have OfficeXP pro
installed on them.

If the application is left running for more than a couple
of days, the client receives a 'Disk or Network error'
and the user has to exit out of Access. They're able to
start the application after that with no issues, but then
the cycle begins again. The strange thing is the same
application runs fine in Win95 (yes, we still have some
Win95 clients!).

Does anyone have any recommendations on how to
troubleshoot this? We don't think the issue is with the
network since Access is the only application that seems
to get the error.

Thanks in advance,
Mateo

 

[Kevin3NF]

Almost every network has a glitch on occassion, which Access is very
susceptible to. I recommend to every client that they close the application
when done. Sounds like this would work for you as well from what you
describe.

Is the app split into FE/BE?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Luke Bellamy]

Hi Mateo,
Sounds like a corrupt file to me. There are several causes of this and
solutions for you. Best bet to get an understanding of this so have a look
at all the good stuff at:
http://www.granite.ab.ca/access/corruptmdbs.htm

HTH

 

[Mateo]

I've made this recommendation to the users but also
committed to try to find a permanent resolution. I didn't
write the app, but I do believe it is split into FE/BE.
Thanks for your response.

~Mateo

 

[Guest]

A repair is run on the database regularly and I don't
think to this point they've experienced any data
corruption.

 

[Tony Toews]

If the application is left running for more than a couple
of days, the client receives a 'Disk or Network error'
and the user has to exit out of Access. They're able to
start the application after that with no issues, but then
the cycle begins again. The strange thing is the same
application runs fine in Win95 (yes, we still have some
Win95 clients!).

Does anyone have any recommendations on how to
troubleshoot this? We don't think the issue is with the
network since Access is the only application that seems
to get the error.

Interesting symptom.

But how does the client do a backup if they don't get out of Access?

For this reason alone I'd kick everyone out for at least a few
minutes once a day.

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

 

[Luke Bellamy]

You are right... I was took quick to jump in when
I saw "Network Error" which I have seen and fixed
through Tony's web site.

Mental note:
Think before you type.... think before you type...