By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Security Issues

LMHelper
P: 12
A while back I had set up security permissions on a database to test the possibilities with other employees here at Lockheed Martin. I set up groups with permission levels and one of them was for my backup who sits on the other side of the building. She would have to use a user ID and password to get into the database. Now that database does not exist any longer - it was a test - and the REAL database that has NO set security permission levels or groups is the actual one I want her to get into. She should not have to use a User ID and password to get into this one due to no security permissions set. WELL - she still has this "pop up" come up on her desktop at her location when trying to open the REAL database. How do I get that to go away for her? I tried to even recreate the database as another name and in another location to see if that would work and it did not. Anyone else can get into it but her.

Help!
Jun 8 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,315
A while back I had set up security permissions on a database to test the possibilities with other employees here at Lockheed Martin. I set up groups with permission levels and one of them was for my backup who sits on the other side of the building. She would have to use a user ID and password to get into the database. Now that database does not exist any longer - it was a test - and the REAL database that has NO set security permission levels or groups is the actual one I want her to get into. She should not have to use a User ID and password to get into this one due to no security permissions set. WELL - she still has this "pop up" come up on her desktop at her location when trying to open the REAL database. How do I get that to go away for her? I tried to even recreate the database as another name and in another location to see if that would work and it did not. Anyone else can get into it but her.

Help!
When you join a security group, it joins for that instance of Access. Access workgroups are not a database-level security system. It's a program-level system. Which means you can't just set up the workgroup on your database and send it out, each computer has to join that workgroup.

Just join her back to the default security group.
Jun 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.