BI tool (Prism) and Access

[erin7690]

Hi,

I use SiSense Prism over my Access Database to create reports and distribute them to executives. This tool can execute SQLs directly over Access, but when I do this - sometimes the query fails, usually when it has several complex measures defined.

The guys at SiSense said that when you execute queries directly over Access, I am bound to the limitations imposed by Access's querying engine. How is Access's querying engine, compared to SQL Server for example? I may need to consider migrating.

Thanks

 

[Uncle Gizmo]

I would ask The guys at SiSense.