VBA, Creating stored-procedures

Creating stored-procedures

Author	Message
Jim Ferguso #1 / 4	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/
Sun, 04 Jul 1999 03:00:00 GMT

Sybrand Boonstr #2 / 4	Creating stored-procedures Hello, 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? Many thanks in advance!! Sybrand Boonstra,
Sun, 04 Jul 1999 03:00:00 GMT

Dan Haugh #3 / 4	Creating stored-procedures In addition to Jim's response, you should be taking a close look at ODBC-Direct. This extension to DAO (new in Access 97) allows you a great deal of flexibility in dealing with server data, stored procedures, views, cursors and transactions. Search Access on line help for ODBC Direct for more information. This new feature is one the top 3 new features in Access 97, and makes Access as capable (and better in many cases) than Visual Basic for client/server development. -- Dan Haught FMS Inc. http://www.fmsinc.com Quote: > Hello, > 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? > Many thanks in advance!! > Sybrand Boonstra,
Mon, 05 Jul 1999 03:00:00 GMT

Richard Steij #4 / 4	Creating stored-procedures 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? Well dear Sybrand, just read the report I wrote after migrating the "activiteitenscherm" to SQL-server. In this report an example of what u're asking for is included. Greetings richard steijn
Fri, 09 Jul 1999 03:00:00 GMT

Page 1 of 1

[ 4 post ]