Solved

Disk I/O error on network DB

Posted on 1997-12-16
2
190 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now