I have an Access database with ColdFusion to display data over the web.
We are currently creating a separate table for the web, from multiple tables with relationships and updating it daily.
I would like to create an Access query that has all the web data.
Can ColdFusion connect to a query in Access instead of a table?
Can I avoid creating relationships in ColdFusion by creating a query in Access?