Skip to Content

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

MS Access versus SQL Server

Folks,

I've created a Crystal Report, querying SQL Server. I'm wanting to change the datasource location to an MS Access db (db and table structure exactly the same) but the query fails.

Here's the query against MS SQL Server and succeeds:

SELECT "AddressList"."AddressLine1", "AreaAddressList"."AreaID", "AreaAddressList"."ProjectUPRN", "Area"."AreaDescription" 
FROM ("test"."dbo"."AddressList" "AddressList" LEFT OUTER JOIN "test"."dbo"."AreaAddressList" "AreaAddressList" ON "AddressList"."ProjectUPRN"="AreaAddressList"."ProjectUPRN") INNER JOIN "test"."dbo"."Area" "Area" ON "AreaAddressList"."AreaID"="Area"."AreaID"

Here's the query against MS Access and fails:

SELECT `AddressList`.`AddressLine1`, `AreaAddressList`.`AreaID`, `AreaAddressList`.`ProjectUPRN`, `Area`.`AreaDescription` 
FROM (`AddressList` `AddressList` LEFT OUTER JOIN `AreaAddressList` `AreaAddressList` ON `AddressList`.`ProjectUPRN`=`AreaAddressList`.`ProjectUPRN`) INNER JOIN `Area` `Area` ON `AreaAddressList`.`AreaID`=`Area`.`AreaID`

any ideas?

thanks

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