Article ID: 137023
Article Last Modified on 11/18/2003
DBEngine.Idle dbFreeLocksThis line of code is needed only for databases saved in Microsoft Jet versions 1.x and 2.x. Databases created with Microsoft Jet version 3.0 do not exhibit this behavior, and programs written only to manipulate Jet 3.0 databases do not require the call to the Idle method.
Dim db As Database Dim ds As Recordset
Private Sub Form_Load()
' Replace the next line with the path to your VB 4.0 directory:
Set db = DBEngine(0).OpenDatabase("c:\vb\biblio.mdb")
Set ds = db.OpenRecordset("Authors")
End Sub
Private Sub Form_Unload()
ds.Close
db.Close
End Sub
Private Sub Timer1_Timer()
Dim s As String
s = Time$ + " / " + ds("Author")
Label1.Caption = s
End Sub
DBEngine.Idle dbFreeLocks
Additional query words: 4.00 vb4win vb4all
Keywords: kbprb KB137023