How do you call an SQL Server Stored Procedure from Access?

K

Kevin3NF

Not very glamorous, but it works for me (you would want to add some error
handling):


Private Sub cmdRefreshClientPmts_Click()

Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider = SQLOLEDB;Data Source = ServerName; " & _
"Initial Catalog=dbname; User id=someusername;
password=somepassword"
cnn.Open

cnn.RefreshClientPmt 'This is my stored procedure call

MsgBox ("Records refreshed")

cnn.Close

End Sub


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
M

Marco Napoli

Thank you so much.

Marco

Kevin3NF said:
Not very glamorous, but it works for me (you would want to add some error
handling):


Private Sub cmdRefreshClientPmts_Click()

Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider = SQLOLEDB;Data Source = ServerName; " &
_
"Initial Catalog=dbname; User id=someusername;
password=somepassword"
cnn.Open

cnn.RefreshClientPmt 'This is my stored procedure call

MsgBox ("Records refreshed")

cnn.Close

End Sub


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Accessing Stored Procedure via VBA 4
Access can't find stored procedure after scripting on sql server 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Stored procedure as row source for a combo box 4
The stored procedure executed successfully but did not return any records 4
Stored procedure recordset not opening 9
SQL Server Stored Procedure timeout 3

Top