469,607 Members | 2,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,607 developers. It's quick & easy.

Jet User-Level Security

58
Basically I have Three questions about Jet U-L Security:

1.Every time I create new Groups, new Users and Permissions using the User and Group Accounts dialog box, It creates User security for every single DB Access file I have in my system. How can I get a Jet User-Level Security only for the current opened file without using the User-Level Security Wizard?.

2. Also, Is there a way to view and make changes to Groups and Users opening the User and Group Accounts and Permissions dialog boxes after the Group and its Users are created with the U-L Security Wizard?

I feel too limited using the Wizard and I rather use the User and Group Accounts and Permissions dialog boxes to manipulate Groups and Users.

3. If I create User-Level Security with MS ACCESS 2007 at a Network level. Am I going to have compatibilities problems with 2000 version workstations?

If anybody can give me a hint about these concerns, it would be great.
Thank you in advance,
Plaguna
Sep 2 '08 #1
6 1754
ADezii
8,800 Expert 8TB
  1. You can use the /wrkgrp Command Line Switch to open a Database with a specific Workgroup Information File as in:
    Expand|Select|Wrap|Line Numbers
    1. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /wrkgrp "C:\Test\Top_Secret.mdw"
  2. No matter what the mechanism by which you create your User and Group Accounts, they should all be able to be managed via the GUI (Tools ==> Security ==> Blah, Blah Blah...)
Sep 3 '08 #2
plaguna
58
I think question #1 was not well explained. Letís start all over again.
I have MS Access 2007 (My Database files are saved as .mdb extension). I have no problem to create Users and Groups, and grant them specific Permissions. What I donít understand is why when I create Password, and Permissions to allow or restrict the access of users and Groups to the objects in a specific Database file, (Ex: for only Sales.mdb) it creates security password for all (*.mdb) files. Some DB files donít need any type of security password. The idea is to create User-Level Security and security passwords for individual Database files. I tried everything, and nothing works. Can anybody has an idea how to do this?
Thank you in advance

Plaguna
Sep 3 '08 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi Plaguna. Please do not double-post your questions. You have started a new thread linked here instead of being patient and waiting for a response to post #3.

MODERATOR
Sep 3 '08 #4
plaguna
58
I'm sorry about that
Sep 3 '08 #5
ADezii
8,800 Expert 8TB
I think question #1 was not well explained. Letís start all over again.
I have MS Access 2007 (My Database files are saved as .mdb extension). I have no problem to create Users and Groups, and grant them specific Permissions. What I donít understand is why when I create Password, and Permissions to allow or restrict the access of users and Groups to the objects in a specific Database file, (Ex: for only Sales.mdb) it creates security password for all (*.mdb) files. Some DB files donít need any type of security password. The idea is to create User-Level Security and security passwords for individual Database files. I tried everything, and nothing works. Can anybody has an idea how to do this?
Thank you in advance

Plaguna
Question #1 was well explained and the answer is still the same. When you establish a Security Mechanism via Users and Groups within an Access Database, it is 'Global' to Access and affects all Databases unless you specifically Join another Workgroup (say the generic System.mdw which is not secured). You cannot have a Secured and Unsecured Database working off the same Workgroup Information File.
Sep 3 '08 #6
plaguna
58
Now I see what you mean. I'll try to solved it based on that concept.

Thank you
Sep 8 '08 #7

Post your reply

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

Similar topics

60 posts views Thread by Fotios | last post: by
2 posts views Thread by Sandman | last post: by
5 posts views Thread by Michelle Stone | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by
3 posts views Thread by shapper | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.