The 'Microsoft.ace.oledb.12.0' provider is not registered on the local machine

Download and install office 2007 data connectivity components

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

Dynamics GP - Integration Manager "This item is not effective"

When trying to integrate an item, you get an error saying "This item is not effective".

This is because the item is not activated in the manufacturing module.
To activate the item go to

Cards>Manufacturing>Inventory>Engineering Data>Enter Item>Change Status to Active

The Best Free Apps List

Antivirus - Avast http://www.avast.com/en-au/free-antivirus-download
Photo Editor - PhotoScape http://www.photoscape.org/ps/main/index.php
Remote Assistance - Teamviewer http://www.teamviewer.com/en/index.aspx?cdsplit=C
Scheduled Tasks - Splinterware System Scheduler http://www.splinterware.com/products/wincron.htm
Torrents - uTorrent http://www.utorrent.com/
Virtual Drive - Virtual Clone Driver http://www.slysoft.com/en/virtual-clonedrive.html
Zip / compression - 7zip http://www.7-zip.org/
Process Maps - yED http://www.yworks.com/products/yed/download

VM Recipes - Windows 2003 R2 with SP2 32-bit, SQL2k5, Dynamics GP 10, Business Portal 4.0 SP2

Business Portal 4.0 CANNOT be installed on 64-bit.

Business Portal 4.0 works on 32-bit only.

• Download Windows Server 2003 R2 with SP2
• https://msdn.microsoft.com/en-gb/subscriptions/securedownloads/hh442898#searchTerm=windows%20server%202003%20standard&ProductFamilyId=0&Languages=en&PageSize=10&PageIndex=0&FileId=0 
• Download SQL 2005
• https://msdn.microsoft.com/en-us/subscriptions/securedownloads/hh442898#searchTerm=sql%20server%202005%20standard%2032&ProductFamilyId=0&Languages=en&PageSize=10&PageIndex=0&FileId=0
• Download Business Portal 4.0
• Download GP 10
• https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp2010_release_download.htm?printpage=false&sid=y4f4120zeb5hzlxdaeomdu2t&stext=product release downloads for Microsoft Dynamics GP 10
• Download Business Portal Service Pack 2
• https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp10_bpservicepacks.htm?printpage=false
• Download Windows Sharepoint Services 3.0x64 SP2
• http://www.microsoft.com/download/en/confirmation.aspx?id=5719 
• Install and configure Windows Server
• Rename the computer to something normal
• Set the ip manually 
• Run DCPROMO
• Install and configure SQL
• Install GP 
• Enable IIS on your Windows Server
• Install WSS
• Install Business Portal

Dynamics GP - Download Product

Go to partnersource.
Search for Product Release downloads

https://mbs2.microsoft.com/PartnerSourceApp/search.aspx?qu=product+release+downloads

Dynamics GP - Data Connection is blank after installing client on 64 bit machine

The machine is a 64 bit machine, and the Dynamics GP install does not create a 64-bit odbc connection.

You have to manually create a 32-bit odbc data connection for GP.

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
Run it and create your odbc.
Connect to your sql server using sa
untick all checkboxes on all windows as you go through the setup
next next next
You should see your data connection when you run GP.

http://support.microsoft.com/kb/942976

Dynamics GP - Pre-Requisites

Hardware and Software Requirements for Dynamics GP 2010 R2

https://mbs.microsoft.com/partnersource/documentation/systemrequirements/mdgp2010_technology_requirements.htm?printpage=false&sid=gkpquo3wv0x0z4rpb5gky00r&stext=System Requirements for Microsoft Dynamics GP 2010 r2

Dynamics GP Version Release Numbers

http://www.jivtesh.com/2008/01/great-plains-service-pack-versions.html