Hi,
I use VB6 with Access. I have 4 records in my DBF file. When i do Recordcount, it says that i had -1 record. Why not 4? Help please
Thanks
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim Query As String
Private Sub Form_Load()
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Projects\VB 6\Listbox\Database.mdb;Persist Security Info=False"
Conn.Open
Query = "SELECT * FROM Table1"
Set Rs = Conn.Execute(Query)
List1.AddItem Rs.RecordCount
End Sub