I have had a macro that publishes my data to a SQL server and it has been publishing properly (most of the time). However, it has decided to stop working! I can run the publish manually, and it works fine, but when I execute the macro, I don't get an error message. It finishes right away and tells me it was successful. I've checked my ODBC connection and that's fine. I've checked the datasource in Access Manager and that's also fine. Any other ideas?
Thank you.
Gina
Have you tried to rebuild the macro from scratch?
Yes, I have. I also found out that Analyst does an incremental publish, so if changes aren't made, no publish takes place. I still need to verify that changes weren't made when it doesn't publish. However, it's been working again (after a week of not working)!
Thanks for your help.
Gina.