Jim Lawrence
accessd at shaw.ca
Fri Jul 20 11:11:30 CDT 2012
Mark: Come on you can even do a Command prompt scheduled process that will mail you if something fails... I have such code implemented on four client sites as its brain-dead easy. Never trust something too complex... Schedule via the AT command then when the process batch(es) run... ... :::: Run your overnight application...off the top... C:\local\overnight_process\MyAccess.bat > c:\temp\error.log If errorlevel > 0 goto err for %%A in (%c:\temp\error.log%) do if %%~zA>0 goto err Goto continue :err blat -install MyMail.ISP.net 5 > temp.txt blat c:\temp\bkupfail5.html -attach c:\temp\error.log -to mark at home.com goto end ... Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Friday, July 20, 2012 3:24 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Windows 8 Mail Leaves Users Pining For the Desktop - or Even Their Phones Hans, that's a great mission statement. However, you'll never see Balmer embracing it. Microsoft cannot support what they already have. 1) My client's site has Server 2008 running and we cannot get our task scheduled Access process to email an alert if it fails. This was in Linux years ago. 2) Office 2010 has a beautiful fagade, but if you start to automate it with VBA, you'll discover it's putrid - just a completely bug-ridden mess. So much so, that MSFT has not been able to issue any service packs past SP1. They've just been cobbling a punch of hot-fixes that get secretly issued. 3) This says it all: 1st loss since 1986. Ominous (remember RIMM ?). http://wallstcheatsheet.com/stocks/can-microsoft-bounce-back-from-this-loss. html/ > If I envision a post-Windows world, it is a world where Microsoft > focuses > entirely on selling productivity software, software development > platforms/databases and enterprise applications that run on many > platforms. > > Imagine that... if Microsoft actually focused on the stuff they excel > at, > how cool would that be? Everyone would benefit, Microsoft especially. > > Hans