I have a Macro(call it TestMacro) in MSAccess 2003 Database (call it Bonkers). This macro runs a loop which results in a number of dynamically named reports to be generated in PDF.
Can I open this MSAccess Macro from a SQL Server stored procedure. If so what would the Procedure look like please.
If the Macro cannot be run from SQL Server I have created a Public Function ( call it loopy) could this be run from the SQL Server Procedure and if so what would the Procedure look like please
Thank you in advance