Hi,


I use this code to get a "RecordCount".
How can I get the same result, but FASTER??

Thanks R@emdonck

code:
Dim db_ODBC As DAO.Database
Dim rs_data As DAO.Recordset
dim Connect, MyRecordCount

Connect$ = "ODBC;DSN=" & str_DNS & ";UID=" & str_USER & ";PWD=" & str_PWD & ";DATABASE=" & str_DNS & ";"

Set db_ODBC = OpenDatabase("", False, False, Connect$)
Set rs_data = db_ODBC.OpenRecordset(str_SQL, dbOpenDynaset, dbSeeChanges)

rs_data.MoveLast
MyRecordCount= rs_data.RecordCount

[Edited by R@emdonck on 04-23-2000 at 09:11 PM]