Are you running it in Access Project --> Stored procedure or in VB code?
I remember there should be a place to set the warning on/off... i cannot
recall where to set it now...
but another way to do it is create a vb code and key in
docmd.warning false
then run it...
that should turn off that message...
Ed
[quoted text, click to view] "Nickl" wrote:
> The message I receive is "stored procedure executed successfully but did not
> return records"
>
> "Nickl" wrote:
>
> > When I run a stored procedure from an Access Project I get the above message,
> > and I don't think my users will like it. Does anyone know why this message appears
> > and how I can get rid of it? It happens with or without the "Set NoCount On"
> > line
> >
> > This is how the Proc looks via Access:
> >
> > ALTER PROCEDURE dbo.pDeleteGrowersTemp
> > AS DELETE FROM dbo.tblGrowersTemp
> > SET NOCOUNT ON
> >
VBA code in an Access project and setting the warning to FALSE worked.
Thank you very much.
Just for interest, I had actually set warning to FALSE in the SUb that
called the function that had the Proc, but I actually had to do it in the
function.
[quoted text, click to view] "Ed" wrote:
> Are you running it in Access Project --> Stored procedure or in VB code?
> I remember there should be a place to set the warning on/off... i cannot
> recall where to set it now...
> but another way to do it is create a vb code and key in
> docmd.warning false
> then run it...
> that should turn off that message...
>
> Ed
>
> "Nickl" wrote:
>
> > The message I receive is "stored procedure executed successfully but did not
> > return records"
> >
> > "Nickl" wrote:
> >
> > > When I run a stored procedure from an Access Project I get the above message,
> > > and I don't think my users will like it. Does anyone know why this message appears
> > > and how I can get rid of it? It happens with or without the "Set NoCount On"
> > > line
> > >
> > > This is how the Proc looks via Access:
> > >
> > > ALTER PROCEDURE dbo.pDeleteGrowersTemp
> > > AS DELETE FROM dbo.tblGrowersTemp
> > > SET NOCOUNT ON
> > >
Don't see what you're looking for? Try a search.
