December 31, 2008 at 9:50 am
Is there a way to run a Macro located in MS Access 2003 from a DTS (SQL Server 2K)?
December 31, 2008 at 9:55 am
You'd have to create an Office application automation script or Executable, to then open open the Access app and run the macro. Unless your macro is REALLY doing a lot - it will likely be easier to code DTS to do whatever the macro was doing than to go through all of that trouble.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
December 31, 2008 at 12:09 pm
The macro is only running a set of queries within the database. Is there a way to execute a queries in Access within a DTS? They are really convoluted and will take SOME time to decipher.
December 31, 2008 at 12:21 pm
Then you're back to writing a VB or VB.NET or script component that opens the Access application, and runs the queries from there. There's no way to execute those macros except from within Access, so you'd need to instantiate it and then use Office Automation/VBA to fire them off. Still kludgy as hell, and often not real stable.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply