“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( ) );

Missing File Icon Overlays in Shell Extensions TFS Power tools

I needed to refer to this article several times now, so in hopes of making it easier to find I am putting it here. Really Microsoft only 15 icon overlays???

Why am I not seeing the Icon Overlays in Shell Extensions TFS Power tools ? – Youhanas WebLog – Site Home – MSDN Blogs.

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.