'Stored Procedures' in MDB

Hello to all,

AFAIK there are no 'Stored Procedures' (SP) availible in an MSAccess MDB, aren`t they?

Is there a way to simulate them? Perhaps through custom VBA-Functions?
Even 'Parametrized SP'?

I need to query an MDB (used by another app) on another PC via ODBC.
To limit traffic and usage, i`d like to use SP.

Any way to do this?
Anyone knows a good Manual or Tutorial??

Thanks in Advance.
HaFritz

Hi Hafritz

I encountered a similar problem to yours. After extensive searches I discovered that it is indeed possible to create a stored procedure in Access 2002 onwards. However, since there is only 1 page in MSDN about it, it is clearly an "undocumented" feature that is not recommended.

The VBA code example in the relevant MSDN page also makes the whole business look very unattractive! However, you may be more adventurous than me, so search MSDN for "Access" and "Stored Procedure" and see what you think.

Personally, I'm migrating the back-end of my application to MSDE 2000 which is free(!) with Office 2000 Professional onwards, integrates seamlessly with Access 2000 onwards, and handles stored procedures properly.