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.

Want quick Answers?

Chat Now

Email Now

Call Now

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.