SYMPTOM:
In Strategy Developer 10.x, the warning message that follows is faced during the project duplication across two different metadata repositories from 3-tier in a Microsoft SQL Server 2008 R2 instance to 2-tier in a Microsoft Access 2007 instance:
Operation must use an updatable query.
CAUSE:
This issue was faced in an environment that contained a Microsoft Access ODBC driver older than 4.00.6305.00.
ACTION:
Install the Microsoft Access ODBC Driver also known as Microsoft MDAC layer available in the Strategy 9.3 installation files. It is located by default in the following path:
"\\93_GA_WindowsFullzip\Installations\Utilities\3rdParty\ADO\MDAC_Typ.exe".
