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.

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.

About Us

WSI is a small business and a leading provider of custom access programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom access development experts.