Hi there
I need to execute a stored procedure in SQL Server from Access. I was looking on Google and it says I can do this with a pass through query. Threre are lots of examples on the net but I cant quite follow them? Could anyone explain the process in fairly uncomplicated language please?
There seems to be quite a lot of code I require to execute one SP. This is tre SP I need to run in SQL Server.
dbo.p_upd_BOND_CANCEL 21
If anyone has anyhelp on thi s I would be grateful.
Paul.
I need to execute a stored procedure in SQL Server from Access. I was looking on Google and it says I can do this with a pass through query. Threre are lots of examples on the net but I cant quite follow them? Could anyone explain the process in fairly uncomplicated language please?
There seems to be quite a lot of code I require to execute one SP. This is tre SP I need to run in SQL Server.
dbo.p_upd_BOND_CANCEL 21
If anyone has anyhelp on thi s I would be grateful.
Paul.