CursorType Property Recordset Object Connection Object Connection Execute Method PROPERTY:  Recordset::CursorLocation CursorLocationEnum = recordsetobject.CursorLocation recordsetobject.CursorLocation = CursorLocationEnum The CursorLocation property sets or returns one of the CursorLocationEnum constants that specifies the location of the cursor library. In reality, there are only two choices, client-side or server-side. Typically, client-side cursors are more versatile. However, the default is to the server-side. You cannot change the cursor library for a Recordset while it is open. CursorLocationEnum Constants   Constant Value Description adUseClient 3 Use client-side cursor supplied by the local cursor library adUseClientBatch 3 Obsolete, same as adUseClient adUseNone 1 Obsolete, no cursor service adUseServer 2 Default, use the cursor supplied by provider or database   Code (VBScript): Set objRecordset = Server.CreateObject("ADODB.Recordset") Set objRecordset.ActiveConnection = strConnection objRecordset.CursorLocation = adUseClient objRecordset.CursorType = adOpenDynamic ... objRecordset.Open "ChantList", , , , adCmdTable Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information