Hello,
     I'm trying to develop an application that will run on a few different
Windows machines.  The application needs to make MS Access run a Subroutine.
I'm using ADODB extensively, but running Subroutines seems impossible through
ADODB - if I'm wrong, please let me know!

     I resorted to using ActiceX and the "Microsoft Access x.x Object
Library" because it provides a "run" method for Subroutines.  But because x.x
differs from machine to machine, the application may not find the class it
needs at run-time.

     If it's possible to bundle a specific object library (and it's
dependencies) with my application, and make sure it's registered at run time -
I don't know how to identify all required DLLs, OCXs, OLBs, ???  Also
considering writing seperate DLLs - one for each object-library, and choosing
(at run time) the right one for current environment.

     I'm doing some development under Access 97 (WinXP) and Access 2000
(Win2k) but probably should accommodate Access 200?

Any advice or insight is appreciated!
Cheers.