FIX: Disk or Network Error with Data Access ObjectsLast reviewed: October 30, 1997Article ID: Q114771 |
3.00
WINDOWS
kbprg kbbuglist
The information in this article applies to:
SYMPTOMSError 3043 (Disk or network error) can result when you run multiple instances of one Visual Basic program or you run multiple programs, and all instances or programs perform data access on the same database. If the program does not explicitly close all the data access objects (by using db.close, for example), then the error will occur when the second instance of the program tries to work with a data access object.
WORKAROUNDClose all data access objects (tables, dynasets, snapshots, and databases) explicitly. For example, if your program has any of the following statements
Dim db As database Dim ds As dynaset Dim sn As snapshot Dim tb As table Set db = OpenDatabase("<some database file>") Set ds = db.CreateDynaset("<some query>") Set sn = db.CreateSnapshot("<some query>") Set tb = db.OpenTable("<some table name>")execute the following close statements before the program ends:
tb.close ds.close sn.close db.closeNOTE: If you place the .Close methods in the Unload or QueryUnload events, make sure you invoke these events before your program ends by using the Unload statement (for example, Unload Me). Be careful when using the End statement; it does not invoke the Unload or QueryUnload events.
STATUSThis bug was corrected in Microsoft Visual Basic version 4.0 for Windows.
MORE INFORMATION
Steps to Reproduce Problem
|
Additional reference words: buglist3.00 fixlist3.00 3.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |