Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Stored Procedure for Update


Message #1 by "Dario" <d.mamone@d...> on Wed, 10 Oct 2001 13:48:32
Why I'm not able to use via ODBC or by the Access SQL Window a stored 

procedure written to update a table? The stored procedure is saved, but 

when I try to use it like an sql command, it is not recognized.



thanks in advance, Dario.
Message #2 by Brian Skelton <brian.skelton@b...> on Thu, 11 Oct 2001 01:07:50 +0100
Dario



Are you working with an .mdb? Or an .adp? If you're working with an .mdb 

file, the only way to run a stored procedure is via a VBA function, and 

then only if you're using Access 2000 or later.



-Brian



-----Original Message-----

From:	Dario [SMTP:d.mamone@d...]

Sent:	10 October 2001 14:49

To:	Access

Subject:	[access] Stored Procedure for Update



Why I'm not able to use via ODBC or by the Access SQL Window a stored

procedure written to update a table? The stored procedure is saved, but

when I try to use it like an sql command, it is not recognized.



thanks in advance, Dario.





brian.skelton@b...







  Return to Index