Have an application which runs smoothly on a 32 bit platform, using Access as a temporary working database. The connection string for the ADO Connection is 'Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=' +
strLocation + '\Datadb.accdb' + ';Mode=Share Deny None;'
On the 64 bit Windows system the driver for the above is displayed as the PC has Microsoft Office 2010 - 64 bit installed. However, when executing the application - get a message "Provider cannot be found. It may not be properly installed".
1) Is there a work around for this? or
2) Must we use a different Database?