ADO AbsolutePosition
Hi I am using an Access2002 Database and Accessing it with ADO.
I need to use a Server-Side Cursor to open a very large recordset (about 1.500.000 records).
But it seems that MS-Access does not support AbsolutePosition for Server-Side cursors (put_AbsolutePosition() works for me but get_AbsolutePosition() does not). SQL server supports AbsolutePosition in both Server and Client side cursors.
Is there any other way to determine the absolute position of the record besides using a query such as
"SELECT COUNT(*) AS [RECCOUNT] FROM [table] WHERE [field] < 'myvalue' " which is not as fast as I need it to be? And besides using SQL server 
Thank you
I forgot: the table is sorted on the [field] that is why the above query actually works
Last edited by panayotisk; January 8th, 2004 at 03:01 AM.
Extreme situations require extreme measures
Reply With Quote
