Hi,

what you show looks about right actually..

Although strictly speaking you don't have a prepared statement yet (only when you add objCmd.Prepared = True you'll get a prepared or precompiled command), that's probably not causing the recordset error..

You probably should look at your connection and check whether your provider supports the cursortype / locktyp.. if it doesn't it will actually run under another one...