Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 21st, 2005, 06:40 PM
Registered User
 
Join Date: Feb 2005
Location: Hobart, Tasmania, Australia.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.




  #2 (permalink)  
Old February 25th, 2005, 07:15 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
http://www.pnwadg.org
  #3 (permalink)  
Old March 4th, 2005, 09:45 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
http://www.pnwadg.org
  #4 (permalink)  
Old March 4th, 2005, 03:22 PM
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?

Meg.
  #5 (permalink)  
Old March 9th, 2005, 10:33 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
http://www.pnwadg.org


Similar Threads
Thread Thread Starter Forum Replies Last Post
Object Moved to Here r_ganesh76 General .NET 2 October 14th, 2009 01:12 AM
Active Directory Information ldoodle Classic ASP Basics 0 January 9th, 2006 05:51 AM
Moved from VC6 to VC2003 synaptic Visual C++ 2 August 19th, 2005 09:38 AM
Chapter 8... moved? webmeister BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 September 26th, 2004 03:47 AM





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