I had always been told Access cannot do stored procedures however this microsoft article says otherwise.

http://msdn.microsoft.com/office/und...l/acadvsql.asp

How about that then!