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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy