>With the OLEDB driver, I am trying to get a fast count of rows in a table. If I give it a "select count(*)" and the table is huge, it takes 4-5 seconds. Whereas if I am in the IDE, I can just USE the table and ? reccount() and see it in zero seconds.
>
>Is there anything comparable with OLEDB or ADOX?
>
>Thanks.
Try
oRs.Open("Select Reccount() FROM orders where Recno()=1", oCon)
Maybe you can create stored procedure to return record count?
--sb--