Hi!
I have an access database that is in a network directory.
Here are the steps I've taken so far to secure the db.
1)Created a workgroup file specifically for the database and saved it in the same directory.
2)Created myself as a user and set admin password.
3)Removed admin from Admins group and created my own Admins2 group.
4)Removed all access from Users group and Admins group.
5)Created new database and imported objects.
I think that's about it.
Here's my problem. My users cannot get into the database. The message says they do not have permission, which is a good thing because that means it's protected (for the most part). But they are also NOT getting the prompt. On the other hand I'm getting prompted for every database I try to open. it's like I'm making changes to the system, not the security file for the database. Please HELP! I've been working on this for days and I can't figure out whats going on.
THANK YOU!!!!!
I have an access database that is in a network directory.
Here are the steps I've taken so far to secure the db.
1)Created a workgroup file specifically for the database and saved it in the same directory.
2)Created myself as a user and set admin password.
3)Removed admin from Admins group and created my own Admins2 group.
4)Removed all access from Users group and Admins group.
5)Created new database and imported objects.
I think that's about it.
Here's my problem. My users cannot get into the database. The message says they do not have permission, which is a good thing because that means it's protected (for the most part). But they are also NOT getting the prompt. On the other hand I'm getting prompted for every database I try to open. it's like I'm making changes to the system, not the security file for the database. Please HELP! I've been working on this for days and I can't figure out whats going on.
THANK YOU!!!!!