Characteristics of the Recordset Object

Perhaps the best way to appreciate some of the important characteristics of a recordset is to consider the method that we use to create a recordset – the Open method. Perhaps the strangest-looking line in ourlast example – and certainly the longest – was the line that used the Open method to open our recordset:

  objRS.Open "Movies", strConnect,adOpenForwardOnly, adLockReadOnly, adCmdTable

We looked briefly at the five parameters, but we didn'tstudy them in detail. So let's start work on the demystification of the Recordset object by looking at the syntax of the Open method:

recordset.Open Source, ActiveConnection,CursorType, LockType, Options

Let's break down the parameters and examine each of them inmore detail.