[AccessD] A2003: Calling an Update SPROC-Calling a SPROC thatreturns records

Hi team

Thanks for the link Doug. Both this suggestion and Stuarts suggestion are quite
close though Stuart's has a bit more on the fly flexibility

Sadly neither of them worked - though everything is in place. I was also
wondering if it could be done DNSless - this has to go across 4 machines none of
which have DSN connections setup

Many thanks in advance
 
Darren
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, 20 August 2008 12:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003: Calling an Update SPROC-Calling a SPROC
thatreturns records

Try here:

http://rodeworks.com/wp-content/uploads/2008/08/msaccess_and_sqlserver.pdf

It looks like a great article - it was mentioned in the Access Team Blog
today

Doug Steele

On Tue, Aug 19, 2008 at 6:21 PM, Darren D <darren at activebilling.com.au>wrote:

> Hi team
>
>
>
> I need to call some Stored procedures (SPROCS) in SQL Server from my Access
> dB
>
> The SPROCS will be both simple update ones and some of them will return
> results
>
> Does anyone have examples how to interact with both types?
>
> IE Just run one. And with the other get the results back and display them
> in my
> Access dB?
>
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com