
Creating stored-procedures
Hi Sybrand,
Quote:
> We are using Access97 in combination with SQL-Server 6.5.
> How can I define a stored-procedure in Access and then execute it on
> SQL-Server?
Normally a stored-procedure is not "defined" within a client tool such as
Access. You would user SQL Server tools to do this.
However, part of the Upsizing Tools for Access 95 is a little utility that
lets you work with SP's and triggers and so forth using Access. The UT for
Access 95 are available on MS's web site. I don't believe the version for
Access 97 is out yet.
To execute the SP you can use a pass-through query. A pass-through query
basically sends whatever you type directly to the server. See the docs for
more info.
--
-- Jim F, FMS
http://www.*-*-*.com/