Does MS Access support stored procedures on .accdb or .mdb databases? Or are stored procedures only supported when the backend is SQL Server or something else that supports an Access DB engine (Jet / ACE/ MSDE)?

Information is mixed and not quite complete from what I have found on MS Access and Stored Procedures from various sources. For example this Access help file initially looks like Access supports stored procedures.

So, I could for example maintain the total cost of an invoice for each change, or edit, or adding of rows to a sub form.

The macro language editor looks like say this:

So you can loop over data, you have if/then else etc.

It is a very limited language - but they are in fact true real stored procedure code that runs at the table level, and they run 100% independent of VBA or any other code.

And these table stored procedures run:

• when edit data in a form - even forms without code
• when you issue SQL update or modify statements
• when you modify data via VBA recordset code
• if an external ODBC or OLEDB source such as .net c# or whatever modifies data