appending field to recordset
ADO HELP:
Dim rst As New ADODB.Recordset
rst.Fields.Append "xx1", adInteger
rst.Fields.Append "xx2", adChar, 5
rst.Open "test",strcon,adopendynamic,adlockoptimistic,adcmdtable
rst.addnew "xx1","test"
rst.update
get an error on rst.addnew "Item cannot be found in the collection corresponding to the requested name or ordinal."
it seems that the xx1 was not appended.
So how will the fields show up in the database. Can someone give me sample code to append fields to my database.
and
how do you create a mdb database in ADO?
in dao it is simply the createdatabase(path)
in ADO how do you do this?