August 22, 2003 at 7:13 am
Hi there
I still have an old application running on Access 97. I'm creating a macro that run some queries. In that macro i want to run a stored procedure that is stored on the sql server.
How can I do this ?
Thx
J
JV
JV
August 25, 2003 at 4:00 am
Break it up into two steps. One step being some code that will run the proc, the other a macro to call the code. Not certain, but I think in 97 you have to use a pass through query to run a proc.
Andy
August 25, 2003 at 4:40 am
Yes, use SQL pass-through queries or ODBCDirect.
In this cases Jet does no parsing of the query and passes it directly to your server for processing
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 25, 2003 at 5:46 am
Thx guys.
I've found a vba code that works fine.
Nevertheless thx !!!
J
JV
JV
August 29, 2003 at 10:06 am
A great alternative would be to use ADO code. It's merely a COM library to add to the application and you can then do anything that you could with Access 2000/2002 that defaults to using the ADO libraries. I build subs and functions for all Office products that use VBA and use them interchangably.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply