To execute a SQL stored procedure from the VBA code in MSAccess


  • Hi all,

    I have MSAccess as my front end and SQL server 2005 as back end. From the front end MSAccess VBA code, I want to execute a stored procedure which is present in the SQL Server databse.

    The stored procedure accepts 8 parameters and returns 1 result.

    Kindly guide me to execute the stored procedure and capture the result in the front end VBA code.

    Thanks in advance.

    Thursday, June 09, 2011 11:44 AM


All replies