Re: Can not open other Access DBs if joining security workgroup file

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 15:34:15 -0600

"SaudiOnMoon" <SaudiOnMoon@discussions.microsoft.com> wrote in message
news:BD559220-A213-4586-B664-7075FD79F169@microsoft.com...
> Hi,
> I created Security workgroup on Access DB I developed recently. Then I went
> to every user PC and joined to the security file in order to login.
>
> But, from now on, every user when open any other database, it won't open
> unless he re-join the default security file.
>
> Would someone advice how to handle this situation?

Something doesn't sound right. While it is required to use a specific mdw to
open a secured mdb ANY mdw should open a non-secure one. That is because a
non-secure mdb grants full permission to the default user group "Users" and
every account of every mdw ever made is a member of "Users". In fact, you can;t
create an account that is NOT a member of Users even if you wanted to.

Now if what your concerned about is that they always have to "log in" no matter
which file they are using that is exactly because you made their default mdw
file one that requires a login. If you don't want that behavior then change
their default workgroup back to System.MDW and create a shortcut for your
secured app that specifies a different mdw file as a command line argument. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: How to remove Security from Access 2002
    ... However, since you are joined by default to your secure mdw, that is what ... set up on my home MS Access databases so this one should be ... Open Access and go to Tools, Security, Workgroup ... Rejoin the standard system.mdw workgroup file. ...
    (microsoft.public.access.security)
  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... MDW file in a way that prohibits the creation of new databases. ... my understanding of Jet security would ... permissions, which are all stored in particular MDB files. ... ability to create a new database does not give someone the ability ...
    (comp.databases.ms-access)
  • Re: Access 03 Security
    ... I'm using this setup to give specific security permissions to certain users ... explorer and click on my database, it will open under the default mdw file ... No, the mdw is tied to a session of Access, not a database. ...
    (microsoft.public.access.security)
  • Re: Trying to set security levels
    ... It sounds as though your machine is joined by default to the workgroup (mdw) ... On your machine, go into Tools, Security, Workgroup Administrator and rejoin ... > into a .bak file and the new secure database. ... >> Do you mean the secured mdb file or do you mean the secure mdw file ...
    (microsoft.public.access.security)
  • Re: Access security on a server
    ... > After I set up a security workgroup for an Access 2002 ... How do I get the security workgroup ... > settings I've set up on the server to apply across the ... Using this shortcut they will be prompted for a login. ...
    (microsoft.public.access.security)