New security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jonathan (KingsKnight1_at_nospam.hotmail.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 14:09:58 -0400

Hello all,

I thought I understood setting up security but I'm having a problem. I'm
using Access 2002. Here's the scenario:

I start with an unsecured database and I create a new workgroup file.

I open the database with an Access shortcut using the /wrkgrp flag pointing
to the new mdw file.

I add a new user (Admin102) to the Admins group.

I put a password on the Admin user and remove it from the Admins group

I exit Access and open it with the shortcut.

I log in with Admin102 (which is in the Admins group) with no password.

I set a password for Admin102

>From Admin102 I can't open any objects either to run or design. I thought
since Admin102 is in the Admins group it would have complete authority for
all changes.

What am I not getting?

Second question:

This is actually a split database with all tables linked from a separate db.
How do I secure the database with the tables to be consistent with the one
holding the forms, etc? Is this related to my above problem?

Thanks in advance

Jonathan

Relevant Pages

  • Re: Security confusion
    ... I still believe though that you should import all objects into a new database container since ... >> I've never even heard it was possible to do this via the Immediate Window. ... but did you remove the Admin USER from the Admins GROUP? ...
    (microsoft.public.access.security)
  • Re: Advanced Security Issue
    ... > SuperUser, who has no permissions, but is a member of the Admins group which ... > capable of modifying permissions on the database. ... I discovered that if I recreate the SuperUser with my RemoteUser ... > inherited them through the Admins group, ...
    (microsoft.public.access.security)
  • Re: Bulletproofing database with .mde file
    ... > the DDL parameter being irrelevant in an unsecured database. ... She says that a member of the Admins group of *any* default wgf, ... This is effectively saying, IMO, that all default workgroup files have ... SID for their Admins groups. ...
    (microsoft.public.access.security)
  • Re: Bulletproofing database with .mde file
    ... > the DDL parameter being irrelevant in an unsecured database. ... She says that a member of the Admins group of *any* default wgf, ... This is effectively saying, IMO, that all default workgroup files have ... SID for their Admins groups. ...
    (microsoft.public.access.gettingstarted)
  • Re: User has group permissions to object, but still denied access.
    ... specific queries is identical to queries that she does have the ability to ... permissions depending on where the file is, it means she's either opening the ... about 80 queries in the database, and I haven't been able to find a pattern ... The Admins group was given full permissions. ...
    (microsoft.public.access.security)