I am running Access 2000 with SQL Server. Before switching to ADO from DAO, I was able to Open a recordset built on parameter input and then add new records as well as update the records within that recordset. I'm assuming the only way to do this in ADO, is to use the Command property since I'm dealing with Parameters. The following code will not let me Add new records.
Set Rst1 = New ADODB.Recordset
Set Cmd1 = New ADODB.Command
Cmd1.ActiveConnection = Comm1
Cmd1.CommandText = "sp_Test"
Cmd1.CommandType = adCmdStoredProc
Set Parm1 = Cmd1.CreateParameter("@ZDate", adDate, adParamInput)
Parm1.Value = ZDate
Set Parm1 = Nothing
Set Rst1 = Cmd1.Execute()
Do I need to open another recordset referencing the Table? Also, if I just want to Requery the recordset leaving the Parameters unchanged, is that possible, or do I need to send another Command? Help would be appreciated. Thanks.