using ActiveX, making application portable. "jadn" <u18284[ at ]uwe> 31.01.2006 22:05:30 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.

Re: using ActiveX, making application portable. "jadn" <u18284[ at ]uwe> 01.02.2006 00:34:52 Hi, First, Sorry for posting to wrong forum! Second, problem solved. Don't need app automation to run a MS Access Query (which Can call a Module.Function...) jadn wrote: [Quoted Text] >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.

Re: using ActiveX, making application portable. "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 01.02.2006 02:49:06 ADO is incapable of running VBA code. It's only intended to access data. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "jadn" <u18284[ at ]uwe> wrote in message news:5b32ca5dc7457[ at ]uwe... [Quoted Text] > 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.