I've created a form to search my database using the Query by Form Using Dynamic QueryDef. Everything is working fine, except... I want to setup file and folder permissions to let a group of Editors to "Edit" the records and everyone else to just have read permissions. I have this working up until the readOnly users try to run the code to: Firstly Delete the dynamic query
and secondly create/recreate the Dynamic query
Is there perhaps a way to tackle the dyanmic query a different way, such as delete the records from just the query and then repopulate it?
Or could someone help with a totally different approach for the security (but staying away from Access Workgroups!). We would like a Read Only group and a Editors/Admin group
Thanks
Code:
Db.QueryDefs.Delete ("Dynamic_Query")
Code:
Set QD = Db.CreateQueryDef("Dynamic_Query", "Select * from [qrySearch] " & (" where " + WC & ";"))
Is there perhaps a way to tackle the dyanmic query a different way, such as delete the records from just the query and then repopulate it?
Or could someone help with a totally different approach for the security (but staying away from Access Workgroups!). We would like a Read Only group and a Editors/Admin group
Thanks