I need just one single record Optimize your code if you know only one record will be used

If you know you are just gonna use one single record ( like when displaying the details for a single article for example ) then be sure to specify MaxRecords, since it makes the drivers optimize their memory allocations and therefore make the call much faster.
        Dim oRS, oConn
        Set oConn = Incdb_GetConnection( Incdb_GetConnectionString(0))
        Set oRS = CreateObject("ADODB.Recordset")
        oRS.CursorLocation = adUseClient
        oRS.MaxRecords = 1
        oRS.Open strSQL, oConn
Information and tips