Sign up ×
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


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 Aug 3 '12 at 0:48

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

Is switching the full version for the runtime for non-admins not an option for you? – Remou Aug 2 '12 at 22:43
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


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

Browse other questions tagged or ask your own question.