MS Access - Failed to retrieve data from the database
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,