Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 07-27-2012, 12:03 PM   #1
Newly Registered User
Join Date: Jul 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
RockinJ is on a distinguished road
sercurity and login forum and relationships and sliting DB

here is what happened i think. so I am building this database for a tutoring center called TRiO services at University of Montana, this is my first full on database I have built and I am getting close to finishing it, so what happened I think is I downloaded a example database to look at and it was 07 access DB and the security level features on 07 formatting allow SLU. So i was looking into the security features and opened the wizard for user level account security and made I new group I think in this example database because I wanted to see what type of security I wanted to use on my DB (if that makes sense). so I think by turning this feature on in the 07 example DB it turned on the feature for all access files. so every time i open an access file I have to login as admin or users (ULS). so the thing is I want to get rid off this feature and just encrypt the DB because 2010 formatting doesn't allow ULS from what I understand so I need help getting rid of this feature, it seems like others replaced or resaved a securtiy.mdl or system.mdl or something like that which returned it to its default settings (if that makes sense...)

thanks jesse f

P.S. I need help with some or problems too to finish this DB up
want to have my login in forum I created use the table I have of usernames and passwords.

also would like a second opinion on how i have my relationships set up

and when you split a database and the wizard creates the back end for you do you just delete the tables in the front end and is there a wizard for establish or reconnecting the tables.....

RockinJ is offline   Reply With Quote
Old 07-27-2012, 06:44 PM   #2
Pat Hartman
Super Moderator
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,253
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: sercurity and login forum and relationships and sliting DB

Welcome Aboard What you are experiencing is the major reason that ULS was deprecated. All Access databases in A2003 and earlier are secured. You are just not aware of it because unless you have created a custom work group and logged into it, Access just uses the default System.mdw and logs you into that as an Admin.

If you created a workgroup with a name other than System.mdw, your System.mdw will still be unaltered so you can just rejoin it and all databases will appear to be unsecured again. If you modified System.mdw, you will need to locate a clean copy so you can join it. I have attached a clean copy you can use.

In the future, if you have to work with a database secured with ULS, create a shortcut and add /wrkgrp workgroupname.mdw as parameters. If you join a workgroup, Access updates the registry with that information and that is why all subsequent applications appear to be secured (they aren't really). You are still connected to the secured workgroup until you join another. Once you join the clean workgroup I sent, that will update your registry and you will be fine. When you use the /wrkgrp runtime argument, the registry is not updated so other databases don't act like they are secured when they are not.

This is the Access Security FAQ. http://support.microsoft.com/kb/207793 It will explain in more detail what I summarized here and it will tell you how to correctly secure a database should you want to.
Attached Files
File Type: zip Unaltered_System.zip (100.4 KB, 68 views)
Bridge Players Still Know All the Tricks

Last edited by Pat Hartman; 07-27-2012 at 06:50 PM.
Pat Hartman is offline   Reply With Quote

access 2010 , login , logon , security , split

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Password Login Screen with session login recording DCrake Sample Databases 18 08-06-2019 03:48 PM
Administrator Login OK User Login not good. sjdeetz SQL Server 1 12-02-2011 02:25 PM
Secure forum login Guus2005 Site Suggestions 0 04-20-2009 02:27 AM
All Relationships disappear from Relationships window chris klein Tables 2 03-23-2009 01:26 PM
Forum login problems and blank index page Jon Site Suggestions 15 12-01-2005 09:57 AM

All times are GMT -8. The time now is 05:31 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World