[dba-Tech] ultimate win 8 nightmare

Arthur Fuller fuller.artful at gmail.com
Thu Oct 10 07:00:16 CDT 2013


Just about the only reason that I still have any instances of Windows is
for development in Access and/or SQL Server. Pretty much everything else
that I do, such as writing documents, email, play music, burn DVDs, etc., I
can do just as well or better in Linux.

One sad shortcoming of LibreOffice and OpenOffice is that they don't
support or provide anything equivalent to VBA (the coding language built
into virtually all the MS Office products). That lack prevents migration of
lots and lots of stuff that I've written. For example, grab a resultset
from SQL, pump it into Excel for its charting capabilities, plonk the chart
into a Word document, save the Word document as a PDF and invoke the user's
email client, filling in the "To" and "Subject" stuff from data and
attaching the PDF -- and all this happens as a result of a button-click in
an Access app. That kind of power is sorely missed in the Linux Office apps.

However, I can still get there in a VM running inside Linux. But I wish
that I could cut this last tie to MS, and then say goodbye once and for
all.

A.



More information about the dba-Tech mailing list