|
 |
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...
|
|
 |