Using ColdFusion, cannot reference a saved query in MS Access in a select statement

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

Using ColdFusion, cannot reference a saved query in MS Access in a select statement

Forum: Help

Creator: Carlos Coronel

Created: 2021-10-28

Updated: 2021-10-28

Carlos Coronel - 2021-10-28

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Coronel - 2021-10-28

All tables used in the Access query are local tables.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.