Set acl = proddb.ACL 'Here I get the acl handle...
accPriv = proddb.QueryAccessPrivileges(groupname)
After this line I lose handle of ‘acl’…This is occuring due to ‘QueryAccessPrivileges’ property since when I commented this line I did not lose the ‘acl’ handle
That is weird, I can confirm it’s happening but don’t know why.
Saying that, you don’t need the acl to use queryaccessprivileges, so unless you need it for something else in your code just remove the line, or alternatively swap the lines around as a wrokaround.