Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
SQL Server/Access OLE DB connection help
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have created a job in SQL Server that is intended to export data to an accdb table. I'm using the Microsoft Office 12.0 Access Database Engine OLE DB Provider. Testing the connection in Visual Studio is successful, and running the job from there is successful. However, when attempting to run via Management Studio, an error occurs: Code: 0xC0202009 Source: Test Connection manager "Reports" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not. The step succeeded.
In researching this, there are mostly posts relating to 32-bit vs 64-bit version, but this is in a 32-bit environment. Are there other settings I need to look for to establish this connection?
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.