Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miked1978
Starting Member
25 Posts |
 Posted - 2009-02-13 : 09:22:05
|
| We have an access database set up to run a few hundred complicated charts but the data which feeds the charts comes from SQL (2000) where we have a DTS package/job set-up to update the data once a week.Not sure if this is possible but when we update the data in SQL can we also have a script that would also execute the Access Macro? |
|
|
Bodestone
Starting Member
18 Posts |
Posted - 2009-02-13 : 09:46:50
|
| Not without being a tad ugly about it as far as I am aware.You could though have an access DB with the relevant connections and a single form that has the macro in form/load and that form opened on startup then you could launch the access file from a command line step in the agent job.Not at all tidy and prone to errors under numerous conditions...I am assuming the macro does more than just data manipulation tasks that can be converted into sql tasks. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-13 : 10:00:31
|
| I'm a long time removed from working with access but isn't there a way to call access macros from a command line?Mike"oh, that monkey is going to pay" |
|
|
|
miked1978
Starting Member
25 Posts |
Posted - 2009-02-13 : 10:04:26
|
| Thanks guys it will probably be a little ugly and not worth it. Not a big deal at all. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-02-13 : 10:16:55
|
| http://www.codeproject.com/KB/office/SSIS_Access_Macros.aspxhttp://www.bigresource.com/MS_SQL-Running-an-Macro-from-DTS-Package-mfnIrMy2.html#hR2eMaSH |
|
|
|
|
|
|
Run a Access Macro thru SQL