>I'm trying to open a recordset with no records.
>
>I keep getting the following error :
>

>OLE IDispatch exception code 0 from ADODB.Recordset :
>Arguments are of the wrong type, are out of acceptable
>range, or are in conflict with one another...
>

I'm not sure what are you really want, but you can work with disconnected recordsets like this:

rs = CreateObject("ADODB.Recordset")
With rs
	.CursorLocation = 3 && adUseClient
	.LockType = 4 && adLockBatchOptimistic
	.Fields.Append("Field1", 8, 30) && 8=adBSTR
	.Fields.Append("Field2", 8, 30)
	.Open
	.AddNew
	.Fields("Field1").Value = "qwerty"
	.Update
	? .Fields("Field1").Value
EndWith

There is an interesting article in MSDN about this: "Store ADO Recordset Data Without a Database" (from "Inside Microsoft Visual Basic" Journal).