Solved

Disk I/O Error #3040

Posted on 1997-11-20
6
825 Views
Last Modified: 2008-03-10
We have an Access 2.0 application that uses DAO and ODBC to a SQL Server 6.5 database. The workstations are DOS 6.22, Windows for Workgroups V3.11 on a Novell 4.x LAN. The application also uses Jet 2.5 with Microsoft's TAB.OCX tab control. The database and all DLL's are on the workstation's hard disk and is opened exclusively. However, frequently we get Disk I/O error #3040 occuring in the application. This can happen anywhere within the application and is totally random. Sometimes, running SCANDISK on the PC fixes the problem, but most times the solution is to delete the MDB file and copy a fresh one across. The MDB file is actually not corrupt because Access does not complain about opening it. Because it is a production system, wse usually get the user to delete the file and copy a new one from the LAN so that they can keep working without much interruption. However, as usage grows, this problem is becoming increasingly difficult to support.
Further to chapies first comment: You're right, I am not completely sure that the MDB is not corrupt. Yes, V2.0 of Access came with repair and compact utilities. At this stage, we are waiting for this problem to reoccur and when it does, get the user to email us a copy of the MDB before deleting it and replacing it with a new one. I will post the findings here once this is complete.
0
Comment
Question by:balraj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 3

Expert Comment

by:chapie
ID: 1960401
a corrupt database does not necessarily mean it will not open the file, I have had many experiences with Acc95 losing the ability to modify the Code-Behind-Forms, eventhough it still works, the only solution is to create a new MDB and copy all the objects over (and you think you would still be copying the curroption but it doesn't)

so, my obvious question is are you assuming the MDB is not curropt or have you ran a 'repair' on the database (did Acc2 come with a repair/compact function?? I only have Acc95 & Acc97)
0
 
LVL 3

Accepted Solution

by:
chapie earned 230 total points
ID: 1960402
argghhh, so, what happened, anything, nothing, everything??
0
 

Author Comment

by:balraj
ID: 1960403
Edited text of question
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 3

Expert Comment

by:chapie
ID: 1960404
that's kinda what I figured, but I have instances where people let answered question just sit around....
0
 

Author Comment

by:balraj
ID: 1960405
OK, got an MDB sent by a user experiencing the Error #3040. I put it on my NT workstation (NTFS) and could reproduce the error by opening the database and selecting menu items. I then did a repair on the database and got the following errors:
1. Table <Large Values> was truncated: data lost.
2. Some Memo or OLE objects values from table MSysObjects couldn't be repaired and were deleted.
After this the repair continued and eventually reported that it was repaired successfully. (somehow I don't believe that).
In any case, there is no such table or query or any other object called <Large Values>, so I don't really know what that message means.
Once repaired, I was able to run the database application without the #3040 error. Everything appeared to be normal, but I did not exhaustively test the application, there could well be some impact from the stuff deleted during the repair.

0
 
LVL 3

Expert Comment

by:chapie
ID: 1960406
oops, hopefully you made a copy of the file before running the repair/compact..

well, anyway sounds like (as long as everything gets tested alright), that simply adding a repair/compact shortcut into the Win3.1 environment will work, and when they experience the problem they can run the shortcut



0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 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