How to Assign a assign a SPECIFIC workgroup information file? 3

[ddelport]

It is from utter frustration that I am sending this post. Even MS FAQ how-to ons security hasn't solved my problem. I want to share an Access 2000 database on a network server but want users from their various pc to be able to log in to the database with a username and pasword. I have set up the usergroups, permissions and so forth. I have created a new workgroup information file for this purpose which will also go onto the server (in another hidden folder. My problem is that I am using/designing different databases and I cannot seem to get this database to work off this Specific workgroup info file. I am very new to the security aspect so I am sure I am doing something wrong along the line. How do I configure this? Do I have to seperately configure the setup at every user's pc or is there a way to make the database only working from the intended *.mdw? The problem is that the other pc's can enter my database via their system.mdw without a problem. I have investigated a commandline switch - shortcut but that will still leave a backdoor for the more informed users, which I do not want.

Furthermore is it possible to secure a folder in such a way that the users don't have direct access to it and be able to delete anything without hampering their normal permissions to edit and add record via their form interface?

 

[votegop]

ddelport:

Your answer is in your question...you're just in denial! The commandline switch IS the way to go. It's the ONLY way to go. The only other alternative I know of is to have all your users "join" the same workgroup, which means any and all Access databases they open will be tested against that security profile (NOT A GOOD THING).

 

[JeremyNYC]

Yeah, you'll want to use either shortcuts or batch files. I use batch files, as that gives me a lot more control than shortcuts. There's a write-up an older version of the system I currently use in the Developers' section of my website.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Quehay]

You want users to start with a shortcut that you provide for them. The shortcut will tell Access to start using your MDW (Security) file with a command line switch included in the target file info:
[tt]
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\your_access_app.mdb" /WRKGRP "C:\your_workgroupfile.mdw"[/tt]

Turn your headache into my project!
Jeffrey R. Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[ddelport]

Thanks! Jeremy I have checked out your site earlier via another response to someone else, it is really helpful. How I understand it now is that I will have to use the commandline switch or batch programme to "direct" the database opening with intended .mdw Then I have to create a new usergroup with admin permissions and assign a new user to that and remove Admin user from the admins group and revoke all permissions from both users and admins as well as user and admin? I assume the new usergroup with administrating powers should own the database. Will doing this block anyone to open the database directly in the network folder (using the default system.mdw)?

 

[Quehay]

Make sure that you create a password for the Admin user(even though its permissions may be truncated), since it will remain and access will log anyone in as Admin NULL pwd and no logon prompt if Admin doesn't have a pwd.

Turn your headache into my project!
Jeffrey R. Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[ddelport]

Thanks Quehay - I will do just that!

 

[JeremyNYC]

Yes, fully applied, Access security will keep out anyone who doesn't have the required mdw. I've written up all the steps to secure a database on that security page on my site.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.