How to stop AC2002 ADP

[BJ Freeman]

AC 2002 is doing a lot of
EXEC sp_MShelpcolumns N'ExternalOrderNumbers', NULL, N'id', 1
before each Excute MySP.
it there a way to defeat this?
AC2000 does not do this.


What I really want is a way to send a Execute as a pass thru.
can this be done using currentproject.execute ?

 

[Vadim Rapp]

BF> What I really want is a way to send a Execute as a
BF> pass thru. can
BF> this be done using
BF> currentproject.execute ?

Yes.

Vadim

 

[Vadim Rapp]

BF> What I really want is a way to send a Execute as a pass thru.
BF> can this be done using currentproject.execute ?

currentproject.connection.execute <sql>

Vadim

 

[BJ Freeman]

I use
currentproject.connection.execute "MySToredProceedure"
or
set rs =currentproject.connection.execute( "MySToredProceedure" )

and the profiler shows all the
EXEC sp_MShelpcolumns N'ExternalOrderNumbers', NULL, N'id', 1
for each table of MySToredProceedure.
What I want is to stop this extra traffic.
just a simple send the MySToredProceedure and get back a recordset.

 

[Vadim Rapp]

BF> I use
BF> currentproject.connection.execute
BF> "MySToredProceedure" or
BF> set rs =currentproject.connection.execute(
BF> "MySToredProceedure" )

BF> and the profiler shows all the
BF> EXEC sp_MShelpcolumns N'ExternalOrderNumbers',
BF> NULL, N'id', 1 for each table of
BF> MySToredProceedure.

I opened the adp; opened a module; opened immediate window; executed
currentproject.connection.execute "mystoredprocedure" - and profiler showed
nothing but RPC: completed exec mystoredprocedure.

Vadim

 

[BJ Freeman]

Ok.. now I need to know what you have they don't
this happens with all my XP OS XP office clients.
I am running SQL 7.0 SP6a, if that makes a difference.

 

[Vadim Rapp]

BF> Ok.. now I need to know what you have they don't
BF> this happens with all my XP OS XP office clients.
BF> I am running SQL 7.0 SP6a, if that makes a
BF> difference.

access.exe 10.4302.4219
Microsoft SQL Server 2000 - 8.00.760 (Build 2195: Service Pack 4)
windows xp sp1

Did you try it exactly the way I wrote?

Vadim

 

[BJ Freeman]

I don't have the 2002, which is why I am asking here.
I have clients that have 2002 and they all do the same thing.
I don't have SQL 2000 but SQL 7. they access

when I run the same ADE on 2000 I do not get all this extra communication.
so I figure it has something to-do with 2002.
I am trying to figure out what if anything, I need to tell my clients to-do,
to their 2002 to turn off the communications.

here is the code that is called.
CurrentProject.Connection.Execute
"dbo.ADP_LkUpOrderswithNotracking"
This calls
Procedure dbo.ADP_LkUpOrderswithNotracking

As

set nocount on

execute dbwithactualSP..ADP_LkUpOrderswithNotracking

return

 

[Vadim Rapp]

BF> I don't have the 2002, which is why I am asking
BF> here. I have clients that have 2002 and they all
BF> do the same thing. I don't have SQL 2000 but SQL
BF> 7. they access

BF> when I run the same ADE on 2000 I do not get all
BF> this extra communication. so I figure it has
BF> something to-do with 2002. I am trying to figure
BF> out what if anything, I need to tell my clients
BF> to-do, to their 2002 to turn off the
BF> communications.

After all, you can open support incident with microsoft and ask them.

Vadim

 

[BJ Freeman]

LOL.
thanks Vadim.
I was hoping I would get lucky and have a MSFT person see it here and
respond.
I really hate going thru the hoops with the Script readers as MSFT support
then have to wait for the escalation to happen, so I can talk to someone
knowledgeable.
Almost enough to spring for Acc2002 and a new computer to run it on, so I
can trouble shoot it.