Run macro via ODBC?

[aka_BigRed]

Is there any way to run a macro over an ODBC connection to an Access DB?

For example, to run an append query named appendQuery1 over ODBC I can use the following:


execute appendQuery1;


But is there any way to run a macro in a similar fashion?

 

[boblarson]

I'm confused. Where are you trying to run the macro from?

 

[aka_BigRed]

I'm confused. Where are you trying to run the macro from?

From an application outside of MS Access that has connected to the database via an ODBC connection.

 

[boblarson]

An ODBC (Open DataBase Connectivity) connection is primarily for data functions (data transfers, transformations, etc.). If you want to connect with that other application and do things like run macros, etc. you need to use the COM object model to do it.

 

[aka_BigRed]

Yes, Open Database Connectivity provides the standard of ubiquitous data access. My application can only submit SQL against a backend DB (unfortunately in this case its MS Access) and I can not use VB/COM objects which seems to be the defacto route to accomplish anything in Access.

Thanks for the help, but looks like I'm SOL.

An ODBC (Outside DataBase Connectivity) connection is primarily for data functions (data transfers, transformations, etc.). If you want to connect with that other application and do things like run macros, etc. you need to use the COM object model to do it.