Click to See Complete Forum and Search --> : Can i create stored procedure in access?


ruvyb
July 4th, 2001, 03:42 AM
Can i create stored procedure in access?
not using sql server
thanks ruvy

Cakkie
July 4th, 2001, 04:14 AM
There are no stored procedures in Access. The closed thing that come near them are queries, or multiple queries combined in a Macro. And even then you can't do much more then a few SELECT statements.
if you really need something like that in Access, your better of using VB, or some custom defined functions to use in your queries.

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook