Read Only SQL Statement in Access Passthrough Query

kor

New Member
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
 
Back
Top