I'm trying to remove the ability for users to create databases in Microsoft Access for non-administrators on a few computers.
My issue is that people are creating databases left and right, so I want to revoke those specific users rights to creating databases and only let them edit already created databases instead.
I was thinking of doing this through regedit and removing the "new" option in the file tab, but I don't know how to do this, or whether it is even possible. I already know how to identify the administrators from the users, I just don't know how to edit the registry for this case.
I would be editing
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access EDIT: Or HKEY_CLASSES_ROOT?
If anyone has any advice or experience on this, it would be a great help.
Note: the Microsoft Access Runtime is not suitable for this as it will completely remove the ability to create databases for all users, including administrators, which I do not want to do.