recordset empty

[marknavidstrand]

Hi,

This doesn't appear to be working - the recordcount property of the
recordset object is -1. There are about 10 records in the Access
database, and the field Tracking_Number is defined as Int. Seems like
it should work. ?
thanks in advance!


Sub XDocument_OnLoad(eventObj)
' Write your code here
set cnn = CreateObject("ADODB.Connection")
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=G:\xxxxx\xx\xxx\xxx\xxxxxxx\xxx\Forms Bin Tracking
Numbers.mdb"
set objRecordSet = cnn.Execute("SELECT * FROM Numbers WHERE
Tracking_Number > 0")

End Sub