stored procedure

  • Thread starter Thread starter Ginola
  • Start date Start date
"Cheryl Fischer" replied
No. Access does not have stored procedures.
Click to expand...

But saved queries serve a similar purpose, and can have "code" execute by
calling built-in functions and user-defined public functions defined in the
same database as the query.
 
If you use a adp project, then yes, you can have stored procedures.

Ms-access can connect to a variety of database systems (ms-access it self is
NOT a database).

If you create a adp project, then you can write stored procedures.

You can in addition write stored procedures when you use ms-access to
connect to Oracle, or your database engine of choice. So, the stored
procedures belong in the database engine, and not in ms-access.

If you use the file share engine called JET, then you don't have stored
procedures. However, there are two database engines included on the office
cd, and the MSDE engine does allow stored procedures.

Regardless, since ms-access is not a database, then it is kind of the wrong
question. You can certainly write procedures in ms-access. However, use of
stored procedures is going to depend on what database engine you use. Those
stored procedures are never in ms-access anyway.

So, can most certanly use ms-access with a database engine that supports
stored procedures.
 
Back
Top