adjusting a macro that retreives access data
 

Can anyone help me adjust the "big macro" GetDataFromAccess from the
following link, so that it counts the number of records, not retreive them in
the test examples ?

http://www.rondebruin.nl/accessexcel.htm

Any help would be appreciated.
--
Regards,

timmulla

adjusting a macro that retreives access data
 

You can check the .RecordCount property of the returned recordset. For this
to give reliable results, you need a client-side cursor also. something like
this as far as I remember:

With MyDatabase
.CursorLocation = adUseClient
.Open MySQL, MyConnection, 0, 1, 1
MsgBox .RecordCount
End Sub

NickHK

"timmulla" wrote in message
...
Can anyone help me adjust the "big macro" GetDataFromAccess from the
following link, so that it counts the number of records, not retreive them
in
the test examples ?

http://www.rondebruin.nl/accessexcel.htm

Any help would be appreciated.
--
Regards,

timmulla