So many object libraries to know, so little time

[jadn]

Hi,
I'm trying to write an application that needs to tell MS Access to run a Subroutine. I'm performing queries through ADODB, but it seems the only way to invoke a Subroutine is by using ADO "Microsoft Access x.x Object Library" (please tell me I'm wrong!).

My program is supposed to run on several different Windows machines where "x.x" differs from one to the next. So, the problem is that the application gets compiled, but then can't find an expected class on a different machine. Is it possible to make sure one specific object library gets installed/registerd when my App. is installed? Is it reasonable to make my app smart enough to adapt to whatever x.x it finds?

ANY advice/insight is appreciated!
Cheers.

 

[jadn]

Hi (again),
Co-worker showed me how to call Functions from a Query. Don't need MS Access app. automation to run a Query!

Problem solved.