Stored Procedure with access VBA Button

Asked Jun 26 '15 at 05:07

Active Jul 13 '20 at 12:44

Viewed 545 times

I need to execute a stored procedure in MS Access 2013. I use Access as front end interface which is connected to two databases. One database has a few stored procedures. I need to execute those with push of button in the Access.

Database is connected through SQL Server authentication. I started a button in Access and here is the VBA code behind this button. It's empty and just simply need more code to get it running:

Private Sub UpdateItems_Click()        
End Sub

Here are the parameters to establish the connection and stored procedure name:

Server Name: BOX\SQL2014
User Name: sa
Password: 123456PS
Database: SixBit
Stored procedure name: spRefreshItems

edited Jul 13 '20 at 12:44

Erik A

31,639
12
42
67

asked Jun 26 '15 at 05:07

theAccountant.py

http://stackoverflow.com/questions/18800727/ms-access-call-sql-server-stored-procedure – Tim Williams Jun 26 '15 at 05:48
Note: you should ***NEVER EVER*** use the `sa` account ! Not even in testing. Just **don't do it!** – marc_s Jun 26 '15 at 05:57

Stored Procedure with access VBA Button

0 Answers0

Related