Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
49 Posts
Discussion Starter · #1 ·
I have a Database at work that is protected. I was added to a workgroup so that I could help maintain it. Now whenever I open any other Database I have to give my user name and password, otherwise it won't open. How do I remove myself from an Access User Group so I can move around different databases more easily?

Side note: My initial setup was done through wrkgadm.exe

Thanks,
Moxy
 

·
Registered
Joined
·
941 Posts
It's not about being added to one db's users, it's about having the .mdw file that that file references run all your Access hookups.

I'm guessing that whoever created your security didn't bother to (1) use a new, fresh .mdw file rather than the system.mdw file that is Access's default security handler, and (2) create a specialized shortcut that would open only the Access file in question with only the custom .mdw file in question, leaving the rest of your Access connections alone.

Look at the properties of the shortcut you use to open to see if it has a /wrkgrp option on it. If not, this means that it's using the system.mdw default file, and your only option is to replace it with a clean version. You should be able to find one kicking around, either on your machine (I have about 6, but hey, I'm an Access programmer), on an uninitiated user's machine, or on your network. And it just might let you in to that "protected" db without a password, too.

edit: By the way, the mdw file extension denotes a file that controls user-level security for Access. In case you were wondering what I'm ranting about. (I don't like Access user-level security. Can you tell?)
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top