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!