Posts

Showing posts from 2020

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Image
I had an issue today where an Office update caused my C# applications to stop connecting to my access database. I suddenly started getting the error: Here's how to fix it. First, confirm that you do not have Office 12.0 OLE DB Provider by opening up PowerShell and running this command (New-Object system.data.oledb.oledbenumerator).GetElements() | select SOURCES_NAME, SOURCES_DESCRIPTION This screen shot was taken after I fixed my computer. It shows ACE.OLEDB.12.0, 15.0, and 16.0. If you don't have these, run the Access 2016 runtime installer from: http://www.microsoft.com/en-us/download/details.aspx?id=50040

Remote Desktop (RDC) in only 2 of 3 monitors

I'm currently using a laptop at home to connect to work. I would normally VPN in and use Remote Desktop Connection to access my office desktop. My laptop is connected to a dock which is then connected to 2 big monitors - so I have 3 monitors in total. However, I only want RDC displayed in the 2 big monitors, leaving my laptop screen for my local apps (meetings, chats, and other communication tools). By default, Microsoft RDC only gives you the option to use a single display (by choosing the resolution), or to "use all my monitors". Here's a simple trick to overcome this. First, identify your monitors using the mstsc /l command. This will give you the list of monitors you currently have. Take note of the monitor index numbers (0, 1 ,2 , etc) Open Remote Desktop Click Show Options Type in your Computer Name Click Save As and save the RDP file/shortcut Look for the RDP file that you saved and open it in Notepad  Look for use multimon:i:0 and change it to u...