Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MS Access - Failed to retrieve data from the database

Hello,

I've developed a quite complex report (CR XI) from a SQL Server 2005 database. The report contains a number of inner and outer joins and a subreport.

I have a duplicate copy of the database held in MS Access. If I attempt to change the datasource location to the MS Access database, I'm unable to run the report and get the following error:

Failed to retrieve data from the database.

Details: ADO Error Code: 0x80040e14

Source: Microsoft JET Database Engine

Description: Join expression not supported.

SQL State: 3000

Native Error: -540806602 (Database Vendor Code: -540806602)

By changing every outer join to an inner, the report pulls in data but obviously not what is required. It seems as though it doesn't like the outer joins.......

Would this be in some way due to limitations with the JET database engine?

Thanks in advance,

Dom

Former Member
Not what you were looking for? View more on this topic or Ask a question