Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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
 
Old March 3rd, 2005, 03:27 PM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Security problems with WG and XP and more

I have an Access database that is using user level security. However, I have found that users who are not connected to the workgroup can get right into the database without a password. Since there are users who have admin rights to the directory I am forced to store the mdb file in and I have no control over whether or not they join the workgroup file these users can access the data when they should not. Also, I have not been able to find the workgroup Admin tool on XP to make XP users join the workgroup, so they have been able to get right into the DB. So, I have put a database password on the Access database which forces me to go through 2 login screens (since I am hooked to the workgroup) to get in to the database. More important, my VB code that uses the database can access everything fine that existed before the password was added, but everything after (like queries) it gets a permission error (even though the password has been added to the connection string!) So, I am at a real loss as to what to do to undo this chios. Any advise would be most welcome.

Meg.
 
Old March 4th, 2005, 09:10 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

It sounds like you have the same problem Quixote had. See http://p2p.wrox.com/topic.asp?TOPIC_ID=26935

If you correct that problem, you can remove the database password and you won't need the password on your connection string. Your permission error may be due to the fact that the user you're specifying in your connection string doesn't have the proper user level security permissions to the queries.

The workgroup Admin tool isn't related to XP. It's part of Access (Office). You can gain access to the Admin tool from the Tools|Security menu.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old March 4th, 2005, 12:25 PM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That is most helpful. Thank you!

Meg.
 
Old March 4th, 2005, 03:24 PM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having the same problem, but I tried what was suggested in the referred chain. 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?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems installing IIS 5 on XP-M.C.E. 2002 urbanwebdev Internet Information Services 2 December 22nd, 2006 07:03 PM
Install problems - VS 6.0 on XP SCRRUN.DLL PDM.DLL jeff4444 Visual C++ 0 December 6th, 2006 08:48 PM
'win98 and xp startup problems lollipox Linux 2 April 8th, 2005 06:32 AM
dual boot problems between fedora 2 and win xp cbahm Linux 0 March 5th, 2005 02:14 PM
Problems Installing VB6 app developed in XP on NT chiefouko VB Databases Basics 16 November 10th, 2003 08:29 AM





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