September 11, 2001 at 1:05 pm
I need to call a stored procedure on SQL 7.0 Server from my Access 97 database. I will be calling the procedure within the VBA code of a form. Any solutions out there?
September 11, 2001 at 3:08 pm
Here are a couple links from MSDN that may prove helpful:
http://support.microsoft.com/support/kb/articles/Q199/7/08.ASP
http://support.microsoft.com/support/kb/articles/Q131/5/34.asp
I found what looks to be a pretty good article about upsizing to SQL from Access that I think also has some good info:
http://msdn.microsoft.com/msdnmag/issues/0600/Upsize/Upsize.asp
I've used DAO some in the past, but I only have Access 2000 on my machine at present. One thing to keep in mind is that you can easily set a reference to ADO 2.x in Access 97 and use ADO to execute proc's as well, though you wouldnt be able to bind to the resulting recordset (if there was one). Not a great idea, but an alternative.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply