Stored Procedure in access

P

Pat

G'day,

I suspect this is a question that might have
been asked before so pls excuse me.

I was wondering if it was possible to write
stored procedures for Access (office 2003). If so, how can
i got about writing it? I know that we can use query
analyzer or enterprise mgr in Sql Server ... how and
where can i do this in Access.

TIA,
Pat
 
D

Dirk Goldgar

Pat said:
G'day,

I suspect this is a question that might have
been asked before so pls excuse me.

I was wondering if it was possible to write
stored procedures for Access (office 2003). If so, how can
i got about writing it? I know that we can use query
analyzer or enterprise mgr in Sql Server ... how and
where can i do this in Access.

TIA,
Pat
Click to expand...

If you're talking about stored procedures in a Jet (Access .mdb)
database, as opposed to a database that uses SQL Server or some other
client/server database as its back-end data store, then you can't really
do it. The Jet database engine doesn't support stored procedures, nor
does it support multiple SQL statements in a single query. You can, if
you want, store a series of SQL statements in a memo field, and have
code that retrieves the contents of that field, parses out the SQL
statements, and executes them one after another.

If you're talking about using SQL Server as your back-end data store,
then you can create a pass-through query that executes a set of T-SQL
statements as if they were a stored procedure, or you can executed a
stored procedure in the back-end database directly.
 
Top