In my experience with SQL Server and Access (2003, but should be same for 2007) executing stored procedures is best accomplished with the Command Object, viz. oCmd = CreateObject("ADODB.Command"). It is also possible to simulate a stored proc in Access (it will not display in the queries but can execute via ADO). If you could post a little more detail about what you are trying to accomplish perhaps myself or someone else and point out the Command Object code.