PLEASE IGNORE - SOLUTION FOUND - Read Only SQL Statement in Access Passthrough Query
PLEASE IGNORE - SOLUTION FOUND
Hi,
First - If this should be in another place, please let me know...
I'm trying to get data from a Progress SQL-92 database with MS Access using a pass-through query. All I need to do is display the data - no updates. The following works but locks the table in question:
SELECT pem_name AS "NAME", pem_num AS "NUMBER", pem_active AS "empActive"
FROM PUB."pr_employee"
WHERE pem_active = 1
ORDER BY pem_name ASC
I had this same SQL working with LCK=NONE in it but carelessly overwrote the query. Can anyone help me with where I need to insert the LCK=NONE statement? Any and all help is appreciated.
Thanks
PLEASE IGNORE - SOLUTION FOUND
Hi,
First - If this should be in another place, please let me know...
I'm trying to get data from a Progress SQL-92 database with MS Access using a pass-through query. All I need to do is display the data - no updates. The following works but locks the table in question:
SELECT pem_name AS "NAME", pem_num AS "NUMBER", pem_active AS "empActive"
FROM PUB."pr_employee"
WHERE pem_active = 1
ORDER BY pem_name ASC
I had this same SQL working with LCK=NONE in it but carelessly overwrote the query. Can anyone help me with where I need to insert the LCK=NONE statement? Any and all help is appreciated.
Thanks