Microsoft Access Sample Code

Function for using SQL Server - ExecSP

If you are using an ADP, you may find that you want to execute procedures directly against the SQL Server. This is commonly done using a stored procedure, however it can be just plain SQL syntax as well. This handy function allows you to pass in a string (either a stored procedure with the parameters or straight sql) and then it's executed again the sql server.

Function ExecSP(sSql As String) Dim cn As ADODB.Connection Set cn = CurrentProject.Connection cn.Execute (sSql) cn.Close End Function

If you are using an mdb or accdb database - then look at our SQL Functions database template.

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 

Click Here to learn more about the WSI quoting process.