Hi,
I have written a code in MS access VBA to contact SQL Server which is remote. There is a stored procedure in SQL Server that gets executed. I wanted to create a table in MS Access with the output of this stored procedure. The stored procedure does not create a table. The reason is this : The stored procedure returns a set of information one of which is customer number. I have to look for a particular customer#. Currently I am putting the output to a recordset using
Set rsCmd1 = Cmd1.Execute
where Cmd1 is a ADODB.Command and rsCmd1 is a recordset
I am not able to use recordset.Find method . It gives error that Rowset cannot be reset and scanning the recordset using while loop is taking time. I wanted to speed up the whole process of contacting the server, get the whole bunch of info from server, find the customer and put info in text boxes.
Will creating a table speedup the process or is there any other alternative ?
I have written a code in MS access VBA to contact SQL Server which is remote. There is a stored procedure in SQL Server that gets executed. I wanted to create a table in MS Access with the output of this stored procedure. The stored procedure does not create a table. The reason is this : The stored procedure returns a set of information one of which is customer number. I have to look for a particular customer#. Currently I am putting the output to a recordset using
Set rsCmd1 = Cmd1.Execute
where Cmd1 is a ADODB.Command and rsCmd1 is a recordset
I am not able to use recordset.Find method . It gives error that Rowset cannot be reset and scanning the recordset using while loop is taking time. I wanted to speed up the whole process of contacting the server, get the whole bunch of info from server, find the customer and put info in text boxes.
Will creating a table speedup the process or is there any other alternative ?
