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.

Accessing Databases from PowerShell

ODBC Fails in 64 bit environment - Access MDB

Use ACE Drivers and PowerShell to Talk to Access and Excel

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

How to Use Databases from within Windows PowerShell

Using Powershsell to Access SQL Data

Using PowerShell with an MS-Access Database