stored procedures

[philfer]

Hello,

Is it possible to create stored procedures in Access.

I know you can run stored procedures in VBA that reside on an SQL back end. I know that you can create stored procedures on an Access Data Project (but my understanding is that from Office 2007 Microsoft is not supporting ADP).

Thus is it possible to create a stored proc in Access???

Cheers
Phil

 

[pbaldy]

You could probably run a pass-through query that created one, though I've never tried. While I'm not a big supporter of ADP's, I believe 2007 still supports them.