Is is possible to create stored procedures in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying create stored procedures in Access 2003 but cannot find the menu
item under queries. Is this function still supported and if so, where
 
As far as I know Access (mdb) has never supported stored procedures.

MS SQL Server supports stored procedures.

If you are trying to use an Access Data Project (.adp) , then it may be possible.

You can use a passthrough (I think) to use a stored procedure, but again that
cannot be built in Access.
 
The information I had from Access 2000 stated that it could accept/process
stored procedures but the menu items no longer appear in Access 2003
 
All Access queries are stored procedures. They are Stored.
They are Procedures. They are stored procedures. In the
older Access SQL syntax, the keyword 'procedure' was optional,
and was discarded when you stored the procedure.

In the newer Access SQL syntax, the keyword 'procedure'
is used for action queries, and is not discarded when
you store the procedure.

To use the newer Access SQL syntax, use ADO to create
your action queries, or in Access 2003, create a new
database in A2003 ANSI mode. If the database is an
A2003/ANSI database, the default SQL style is 'ANSI'
mode.

(david)
 
Back
Top