| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO recordset returns -1
Philip wrote ...
the default CursorLocation is server-side (adUseServer) with forward only cursors. Yes, but you can specify something other than the default! To navigate ADO recorsets, and get information like "Recordset.Count" or "Recordset.AbsolutePosition" you need to explicitly set it to adUseClient Incorrect. Availability of such properties is determined by cursor type, not location. Any cursor type other than 'forward only' will support the RecordCount property. get information like "Recordset.Count" The Recordset object does not have a Count property. Jamie. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
| Date returns always returns: 00 January 1900 | Excel Worksheet Functions | |||
| Recordset.Recordcount Returns -1! | Excel Programming | |||
| Type recordset/recordset? | Excel Programming | |||
| DAO query/recordset returns with field names | Excel Programming | |||
Threaded Mode
