Hasan Rammaha

Thank you Gord! This explains the issue for me. I will be looking forward to the enhancements in future releases. Best regards, Hasan

Hi Gord. I think I narrowed the issue down to Linked tables vs. Local tables. I managed to rewrite my saved query and got it to run from Lucee. However it worked only when the saved query joined Local tables. When the tables were Linked the saved query could not be run via the driver and gave the usual error of "User lacks privilege..etc". For future releases of Ucanaccess, would it be possible to "Load" Linked tables by the driver and be treated similarly as Local tables? Best regards Hasan

Thank you Gord for your prompt response! I did run Console.bat as you prescribed, I got the same error "user lacks privilege or object not found: XYZ", but this time the Console debug messages revealed more helpful info. As I mentioned earlier, XYZ is a saved query, but what I failed to mention is that XYZ joins 2 "Linked" tables, not local tables. Those 2 linked tables are linked to 2 csv files. When I run XYZ from within Access I get results just fine. The Console showed that it "loaded" a third...

Greetings! I tested using ucanaccess in Lucee (Tomcat-based CFML engine). I can successfully access table objects and run queries as long as I join real tables in Access. However when I try to run a saved query named xyz within Access's "queries" tab, I get the error: UCAExc:::4.0.4 user lacks privilege or object not found: XYZ. This error implies that the driver cannot access query objects directly as in sql "Select * from XYZ". I was able to do so in the past using ODBC. Is this a feature not implemented...