I had struggled with the security warning when I convert my Microsoft Access databases to Microsoft Office 2003. In this version, it has the security warning feature each time you open any file that executes a macro in any of the application in Microsoft Office.
If you get the farm service account password out of sync you properly know your way around SharePoint 2010 pretty well so this article just goes right into the exact what to do to sync up your servers in the farm.
The causes of cron.php fail with 404 error has a lot of theories but the one that I found work for me is "clear cached data". You might also get "Cron job fail" when to try to run manually!