office XP and AC2000 ADP on a SQL 7 server.

[BJ Freeman]

Got this ADP works fine with AC2000.
I am watching the Profiler and AC2002 is sending all these command for
simple execute.
The profiler show this for AC2K
[physicianlaboratories_interfa..sp_procedure_params_rowset
N'Mnu_Switchboarditems', 1, N'dbo', NULL

go
[physicianlaboratories_interfa..sp_procedure_params_rowset
N'Mnu_Switchboarditems', 1, N'dbo', NULL

go
declare @P1 int
set @P1=NULL
exec sp_prepare @P1 output, N'@P1 int', N' EXEC dbo.Mnu_Switchboarditems
@User=@P1 ', 1
select @P1
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON exec sp_execute 1,0 SET FMTONLY OFF
go
sp_unprepare 1

go
SET ROWCOUNT 10000 SET NO_BROWSETABLE ON
go
sp_executesql N' EXEC "dbo"."Mnu_Switchboarditems" @P1 ', N'@P1 int', 1

and work fine


the ACXP shows this

[physicianlaboratories_interfa..sp_procedure_params_rowset
N'Mnu_Switchboarditems', 1, N'dbo', NULL

go
[physicianlaboratories_interfa..sp_procedure_params_rowset
N'Mnu_Switchboarditems', 1, N'dbo', NULL

go
declare @P1 int
set @P1=NULL
exec sp_prepare @P1 output, N'@P1 int', N' EXEC dbo.Mnu_Switchboarditems
@User=@P1 ', 1
select @P1
go
SET NO_BROWSETABLE ON
go
SET FMTONLY ON exec sp_execute 1,0 SET FMTONLY OFF
go
sp_unprepare 1

and give an errror "Value you entered isn't valid for this field "

and does not excute the SP.

any experts on ACXP is there a property I need to set ?
if show what is it so I can put it in the form.

 

[BJ Freeman]

Here is the SP header

Alter Procedure Mnu_Switchboarditems
@User int = 999