Hi Folks,

I have a stored procedure in MSSQL 2005 and it doesn't have any parameters that need to be passed to it.

I'd like to run it using a macro and have tried various examples that I found across the web but all of them produce various errors.

I have an ODBC link set up but ideally I would like the VBA to run without using ODBC to negate the need to set it up on every client computer.

Any help would be much appreciated!

Thanks, Scott.