All tables used in the Access query are local tables.
In a ColdFusion web application, i have a Select query query : "Select * from OpenRequests" OpenRequest is a saved query. I am getting the same error "user lacks privileges or object not found" Does anyone knows how to use saved queries in Access from a ColdFusion app? Any help will be appreciated
I got a similar problem. In the website says that ucanaccess supports running I am trying to run a saved query in Access but got the same error "User lacks privilege or object not found". All tables used in query are local to the database file. Can ucanAccess use saved queries or not? if so how? in the sourceforge page it says "You can execute Select queries defined and saved in Access." Can you show me how to do this?