Can i create stored procedure in access?

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
[email protected]

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