The source parameter (which is not available when the method is applied to QueryDef Recordset and TableDef objects) is the only one that is required. The subsequent parameters (type, options, lockedits) have options that can affect performance.