Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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.




Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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.
Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:14 AM.


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