In vb6 I pulled up the recordset to a datagrid. Is there a way to add records to the datagrid without accessing the db and then when I'm done adding records and making edits, then I can update the Database?
This is how I am opening the database
rec.CursorType = adOpenStatic
rec.CursorLocation = adUseClient
rec.LockType = adLockOptimistic
rec.Open esql, conn, , , adCmdText
Set DataGrid1.DataSource = rec