I posted this on the ODBC dev list but I figured I would post it here
too just incase someone knows the solution to my problem:

Everyone,

So far, connectivity with in Access 2000 has been *excellent* with the
current ODBC driver. However, can anyone point to an example of
someone calling a Firebird SP from Access 2000. All the "googling" in
the whole hasn"t seem to help me. Any pointers would be appreciated.

thanks!

http://tinyurl.com/83hpf