Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Browse other questions tagged .