Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Executing SQL Server Stored Procedures
0 views
Skip to first unread message
Pamela
Mar 4, 1999, 3:00:00 AM3/4/99
to
Hi there!!
Is there a way to execute SQL Server Stored Procedures from within MS Access
97?
TIA,
Pamela
Ding Gung Bawm
Mar 5, 1999, 3:00:00 AM3/5/99
to
Yes, one way is use ADO command object.
Code should look something like this:
Code should look something like this:
Dim cmd as new ADODB.Command
Dim rs as recordset
cmd.ActiveConnect = "DNS=yourDNSname"
cmd.CommandText = "yourStoredProcedureName"
cmd.commandType = adCmdStoredProc
set rs = cmd.execute
Ding Gung Bawm
Pamela <parkerp> wrote in message
news:#4KD$XoZ#GA....@uppssnewspub04.moswest.msn.net...
Joe Fallon
Mar 6, 1999, 3:00:00 AM3/6/99
to
In a Query, use the Menu to make it a SPT query. Then just type the
procedure name.
sp_configure Locks
This runs the stored procedure and returns the number of Locks for SQL
Server.
procedure name.
sp_configure Locks
This runs the stored procedure and returns the number of Locks for SQL
Server.
Pamela wrote in message <#4KD$XoZ#GA....@uppssnewspub04.moswest.msn.net>...
0 new messages