Disk Error Messages

  • Thread starter Thread starter Lance McGonigal
  • Start date Start date
L

Lance McGonigal

Hi all...Thanks in advance for your help.

I have an application that is developed using front-end/back-end method.
The BE sets on a server to floors away. The FE on each PC. I've noticed
lately a lot of disk error messages. If the users are editing a record at
the time of the message the data is GONE.

The sys admin says it's a database problem. I don't really see how it could
be. I used Access 2000 on both FE and BE (not an upgraded app, build from
scratch using 2000) and I use simple linked tables and dynasets for the app.
No opendatabase methods.

Any ideas.

Thanks again for your help.

Lance
 
I have an application that is developed using front-end/back-end
method. The BE sets on a server to floors away. The FE on each PC.
I've noticed lately a lot of disk error messages. If the users are
editing a record at the time of the message the data is GONE.
Click to expand...

1) How many users are interacting at a time? Jet sharing like this should
be okay up to a dozen or twenty, but more is pushing your luck.

2) How robust is the network? Jet is _very_ sensitive to network errors and
a faulty NIC can corrupt a database even when it's not in a machine that is
actually using the app. If that is the case, then you can either persuade
your network admin to fix it, or you could move the application over to
MSDE or SQL Server.

Hope that helps


Tim F
 
Tim...Thanks for your rapid response.

1. 8 users

2. Excellent point. I'm thinking a test of MSDE may be in order.

Thanks much.
 
VERY VERY VERY probable that you are seeing network errors caused by a bad NIC
or router or ...

Access is sensitive to network errors (as are most databases that use the file
server model). One way for you to test this is to move to a computer that is in
the same network segment as the server. If you stop seeing errors, then ....
 
Back
Top