Solved

Disk I/O error on network DB

Posted on 1997-12-16
2
201 Views
Last Modified: 2011-09-20
The data database is located on the network. Each user has the application database on their hard driver. For the last 2 weeks we have been getting Disk I/O errors when using the database. The program locks and either crashes back to windows or has to have Ctl-alt-dlt applied.

I have multiple users - never more than 6 at a time (I have a utility that tells me the most users that have ever used the database.)

The error occurs no matter what the users are doing - viewing a subform, adding records, editing. It doesn't matter if they are looking at the same record as someone else or not. I have even had users get the message when they are the only ones in the database.

I work for a large corporation and have contacted the IT people - they say there are no 'errors logged for the server'. That it may possibly be some sort of communication problem.

This is becoming a MAJOR issue. I have over 75 engineers that depend on the data in this database. It is only 3mb and  has recently been compacted (about the time the errors started). We are beginning to lose data because of partial updates and people are questioning the integrity of the system (NOT GOOD)!

The database has been in use for over 1 year with no previous problems.

I don't THINK it's a problem with my database - but don't know how to prove it. I have users on both Windows 95 and Windows NT but that's never been a problem before.

This is a hodge-podge of info - but I'm hoping someone may have run into this before and can at least give me clue to pass on to the server people.

Appreciate any comments/help!
CEkman
0
Comment
Question by:cekman
2 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 200 total points
ID: 1962768
Hey CEkman. This may have to do with direct hosting feature for the IPX/SPX protocol.

Have a look at Microsoft at the following address:
http://premium.microsoft.com/support/kb/articles/q165/3/51.asp
or search for article nr. Q165351


0
 
LVL 5

Author Comment

by:cekman
ID: 1962769
Trygve-
The 'IT' people said the article did not lead them to a solution. They think it's something to do with loss of communication - but they really don't know. Anyway - this seems to be the best advice I can find from anyone, and if they don't solve the problem soon I'm going to insist they memorize the article word for word. :)

Thanks for the help anyway!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question