Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Aug 3 '12 at 0:48

This question came from our site for professional and enthusiast programmers.

2  
Is switching the full version for the runtime for non-admins not an option for you? –  Remou Aug 2 '12 at 22:43
5  
It sounds like users have a need that they are filling by creating databases. If you just switch off that ability, make sure that their need is filled another way to avoid resentment. –  Eric J. Aug 2 '12 at 22:44
    
I do not understand. Append what? –  johnny Aug 2 '12 at 22:48
    
sigh I know how to do this in Access 2003, haven't tried it yet in Access 2010 though...In 2003 it has to do with mdw files, and mde files –  leeand00 Aug 3 '12 at 0:53
    
Actually it wouldn't hurt if you told us what version you were using –  leeand00 Aug 3 '12 at 0:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.