MS Access and SQL 2000 stored procedures

[Corruptor]

Gents,

before I go mad tell me how is it possible to execute stored procedures in MS Access like in Query analyzer (exec sp_name prams)?

I've tried so many things such as .execute but with no success.

[MAK]

Before that.

1. Do you want to execute procedures that are stored in MSSQL2000 from MS-Access

or

2. you are looking for feature similar to MSSQL2000 procedures in MS-Access

[Corruptor]

I want to execute procedures that stored in MS SQL 2000 server

[MAK]

http://beta.experts-exchange.com/Dat..._20649748.html

[Corruptor]

Thanks MAK but this is exactly I want to avoid. I mean to create QueryDefs in the database, because those are saved in the Access database and therefore will increase its size even if I delete those. Am I right?

[PinkPanther2003]

What are you trying to do?

I would say as a general rule if you can keep the functionality provided by the sproc as a sproc do so. Don't do the processing client side (using Access). Access can be efficent processing queries (eg only drag back indexes not whole tables in some instances so I've read on the NGs, but don't bet on it)

You're better off doing as much processing as possible on the server and then firing the results down to the client side(MS Access) for display/manipulation etc.

a. the Server should be faster at doing the same job

b. you are tying up less network bandwith


If you are trying to bind a results set to a A97 or A2000 form then I don't know of any other way apart from an Access QueryDef.

Peter