panayotisk
January 7th, 2004, 08:20 AM
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
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