“Operation must use an updateable Query” error when updating Excel


Make sure that your connection string does not have “IMEX=1” in it.

private void UpdateEmailSent( string apexId ) {
            try {
                string excelConnectionString = string.Format( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES\";", lmiUserFileTextBox.Text );
                System.Data.OleDb.OleDbConnection MyConnection;
                System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand( );
                string sql = null;
                MyConnection = new System.Data.OleDb.OleDbConnection( excelConnectionString );
                MyConnection.Open( );
                myCommand.Connection = MyConnection;
                sql = string.Format( "UPDATE [Sheet1$] SET [Email Sent] = 'X' WHERE [APEXID]='{0}'", apexId );
                myCommand.CommandText = sql;
                myCommand.ExecuteNonQuery( );
                MyConnection.Close( );
            } catch ( Exception ex ) {
                MessageBox.Show( ex.ToString( ) );

How To Cycle Through Dialog Buttons in Mac OSX Dialog Window

ImageI was working in Lightroom tonight deleting some photos and I was not able to cycle through the different buttons using my keyboard arrow keys in a dialog window. Turns out you have to enable this “feature” by going to System Preferences > Keyboard > Keyboard Shortcuts and selecting the “All controls” option under Full Keyboard Access. Really???


How to read the 64 bit registry from a 32 bit application or vice versa | Rhyous

I was recently trying to update a 32-bit migration utility running on Win7 64 that needs to cleanup some registry entries in the 64 and 32 bit registry HKLM hives. Unfortunately accessing the 64-bit hive was not as obvious as I expected. Came across this article which explains how to tackle this issue.

How to read the 64 bit registry from a 32 bit application or vice versa | Rhyous.