This blog will hold favorite gadgets and graphic user interfaces that don't really fit in my main blog @ mmcelhaney.blogspot.com
Friday, May 30, 2014
Querying Databases With Powershell
I've been trying to get a PowerShell script to query a MS Database for a couple of weeks and no success. I even ended up having to re-image my computer because I ended up trying to install AccessDatabase_x64.exe on Windows 7 and my script began to work - for a short time. Then Office 2010 stopped working. I think the problem was that my OS is Win7 64-bit but my MS Office 2010 is 32-bit. This broke office. I found the fix by running PowerShell as 32-bit. MS Office processor type must match the version of PowerShell running the script. This worked just fine! Here are some links that helped me fix this.