Re: the procedure executed successfully but did not return records

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Bob,

Yes, everything is working much better now.

Many Thanks,

Barry


"Bob" <bobmcc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF24023F-C5D0-47C7-8664-24663CFFE74E@xxxxxxxxxxxxxxxx
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