p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   Secirity information goes when directory moved (http://p2p.wrox.com/showthread.php?t=25862)

Quixote February 21st, 2005 06:40 PM

Secirity information goes when directory moved
I have the security file (*.mdw)in the same directory as the database. It has been set up for the various groups/users. Admin & User grooups/users have had their access removed. Things work well.

I move the directory and I am able to access the database simply by clicking on its icon, it seems the system creates a new .mdw file.

I join my *.mdw file that I set up and check it and everything is still ok. Indeed from that security group I have to enter my password to open the database again before I could check.

But if simply moving the directory to a new area removes the security protection what good is it. Clearly I have missed something. But what? Thanks for any assistance.

rjweers February 25th, 2005 07:15 AM

It sounds to me like you have left the Admin user as the owner of the MDB/E file and/or allowed the Admin user access to objects in the MDB/E file.

Access doesn't really know the difference between Admin in one MDW file from Admin in another MDW file. Hence, when you get the default MDW file by clicking on the MDB/E, you pass security checks. However, it does use a user's "Personal ID" in the MDW file to allow specific users access to objects in the MDB/E.

Try adding a new Admin user and making them the owner. Then remove the "Admin" user's permissions from everything.

Please remember to backup your MDB before you start switching owners and removing Admin user's permissions. If you forget the Password to the user you designate as the new Admin, you're pretty much screwed.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group

rjweers March 4th, 2005 09:45 AM

One thing I should have reminded you of...

The Admin user will have permissions to objects through the Admin User Group. So reassign the default Admin user to a different User Group.

Sorry I forgot that.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group

meggan March 4th, 2005 03:22 PM

I am having the same problem, but I tried what you suggested. I created new groups with the permissions as they should be then set the "Admin" & "User" groups to have no access to anything. Then I made sure the Admin user was only in the "User" group and just to be sure, I set each object to nothing for the Admin user. However, when I go to a users box who has Windows 2003 (I am on Windows 2000) and is not "joined" to the workgroup, they get right in! Still with access to all the data. I am so frustrated with the user level permissions I would really like to get rid of them. Do you know how I can "Unjoin" a group? Or turn-off user level permission and just use a Database password?


rjweers March 9th, 2005 10:33 AM

I can certainly understand your frustration. This Access security thing can be confusing and down right annoying. Especially considering that ultimately it only adds a small level of security to the database -- it isn't that difficult to hack Access security.

But it does work to a certain degree and can be worth the effort. Nevertheless, if you're ready to give up...

To "remove" user level permissions, simply hook yourself up to the workgroup file using Workgroup Administrator then go remove the password from the Admin user.

Considering your struggles, I'm wondering if you even added a password to the Admin user to begin with?

Did you use the User Level Security set up wizard?

Are you working with a Front End / Back End database where your code (forms/queries/reports/etc) is in the front end and the tables are all in the back end? If so, the security needs to be set on the back end to prevent that from being opened directly.

If you're not completely ready to give up, you might want to try "starting over" with a resource at your side. Our book "Access 2003 VBA Programmers Reference" has a chapter on it. And if you're really serious there is one book that is dedicated to the topic. Unfortunately I've forgotten the title/publisher. Sorry.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group

All times are GMT -4. The time now is 03:25 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.