March 25, 2003 at 11:32 am
I am using a SQL pass through query to execute a stored procedure. When I launch the query it runs fine (its a big
sp, so it takes a minute). When I design a report on the query it takes forever to save, open in design view, delete a label... I ran a SQL trace and it appears to launch
the stored procedure many, many times. I am using a DSN and windows authentication to SQL server and my query is simply: exec dbo.spr_ProFee_SUMM_FollowupWIP '1', '2003-03-14 00:00:00.000'
Does anyone know how I can improve this process? I am using Access XP.
Thanks
Brian
.
March 25, 2003 at 2:58 pm
Sounds like you working with it from a mdb. Change over to using the adp functions, and you'll eliminate the majority of your overhead. I won't say that it's not a pain, but that's how to do it.....
March 25, 2003 at 3:18 pm
If I move to an ADP I lose some functionality (easily making cross tab...) As well I need to make it Access 97 compatible.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply