I'm using MS Access and I have a stored procedure which I can run by entering the exec command in a Pass-Through query (linked to the SQL server), the stored procedure is on the SQL server, how can I pass variables from my local machine in to the call to the stored procedure? As it is now I have to rewrite the execution line with the new values to the different variables all the time. I want to be able to pass them on from e.g a form or a table. Do you have to use VBA for this, in that case, how?