Does any one know how to create a recordset with out actuall opening it?

I have dimmed, instantiated (set myrec = new adodb.recordset) but I can't seem use it because of a "Recordset Not Opened" error. How do I open it with out passing a sql or source database.

John P.

John Pennington
 
United Parcel Service
w(404) 828 6934
c (770) 714 5975

__________________
John Pennington
 
United Parcel Service
w(404) 828 6934
c (770) 714 5975

I'm assuming you want to use a recordset as a container for your data, but without it being associated with any data source? If so what you need to do is first add some fields to it, using rs.Fields.Append("Name", Type, Size, Properties) then you can call rs.Open, and finally you add data to it using the AddNew method and then assign values to the fields.

Is that what you're looking for?