Re: the procedure executed successfully but did not return records

Try this Barry...

Dim oCmd As Command, param As Parameter
Dim cn As New ADODB.Connection, sqlString As String

sqlString = "YourStoredProc"
Set oCmd = New ADODB.Command
Set cn = CurrentProject.Connection
Set oCmd.ActiveConnection = cn
oCmd.CommandText = sqlString
oCmd.CommandType = adCmdStoredProc
oCmd.CommandTimeout = 15

oCmd.Execute , , adExecuteNoRecords
cn.close
set cn = nothing

hth.. bob


"Barry George" <bgeorge1@xxxxxxxxxxxxxx> wrote in message news:e$eSlk$FIHA.5980@xxxxxxxxxxxxxxxxxxxxxxx
I am new to sqlServer and am doing an application front end using Access
2003 and the backend sqlServerExpress 2005.

When I run a very simple Stored Procedure on a table called 'MiscCharges'
such as;

SET NOCOUNT ON
UPDATE MiscCharges SET Description='New Description'
WHERE Joborder='1000'

I get the following message: "the procedure executed successfully but did
not return records"

This happens regardless of how I run the SP. Either in the SP window or from
VBA code.

I don't get this message with a simple SELECT sql statement.

What am I doing wrong?



--
Thanks for your help,

Barry George




.

Relevant Pages