RE: Workgroup Security

Tech-Archive recommends: Speed Up your PC by fixing your registry

Couple more questions.

1. Did you set an Admin Password in your new mdw?

2. When you launch the shortcut does it ask you to authenticate with your
username and password?

3. When you go to Tools -> Security -> User and Group Accounts... does it
show the correct user and groups?

If the answers to all three of those are yes, then your security is working.
If you are checking the Workgroup Administrator, then it may show the
default workgroup for access because you are not assigning all databases to
your new workgroup, but the /wrkgrp switch in the shortcut is telling it to
use it for that mdb.

Hope that makes some sense.




"Penstar" wrote:

Still no luck. I have moved database file, and setup new mdw (test.mdw) but,
shortcut, as shown below, opens database with usergroup set to system.mdw
(from "C:\Documents and Settings\Penny\Application
Data\Microsoft\Access\System.mdw")

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"D:\database\copy0405.mdb" /wrkgrp "D:\database\test.mdw"

"Scott Whetsell, A.S. - WVSP" wrote:

Penny,

Your last line for the System1.mdw is what is referencing the default Access
mdw. Change that line to target your new mdw with the users and groups you
want for that mdb. I would recommend placing your target mdb and mdw into a
directory and not directly on the desktop. You could have
C:\MyDatabase\Database.mdb and C:\MyDatabase\Database.mdw, for example.




"Penstar" wrote:

This is exactly what I want to do. However, it doesn't seem to be working.

I have created a shortcut as follows:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and
Settings\Penny\Desktop\copy0405.mdb" /wrkgrp "C:\Documents and
Settings\Penny\Application Data\Microsoft\Access\System1.mdw"

When I open database via shortcut it is still referencing the original
system.mdw file. Have I done somthing wrong here?

Thanks
Penny



"Scott Whetsell, A.S. - WVSP" wrote:

Penstar,

The easiest way to associate a specific database to a specific workgroup
information file (mdw), is to create a shortcut.

The shortcut consists of a couple parts and is as follows:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" -Location of
access
"C:\DatabaseDirectory\DatabaseFileName.MDB" - Location of your database
/wrkgrp "C:\WorkgroupDirectory\WorkgroupFileName.mdw" - Location of your mdw

Place each of those lines, including the quote marks separated by a space in
the target field of your shortcut. This should accomplish what you are
trying to do.




"Penstar" wrote:

I am trying to set up Security for my database. However, when I set up a new
System.mdw file (eg test.mdw) all databases refer to this file. If I "join"
a different workgroup file, all databases on my computer are automatically
using this workgroup file.

Can each separate database have its own .mdw, or do they all run from the
same mdw file?
.

Relevant Pages

  • Re: User access on a company intranet
    ... I did as you said and created a shortcut with the path you gave me and it ... I have built into my database should I disable this? ... When you want to implement security, you create a new mdw file, and follow ... to open the secure mdb is by using the mdw you created. ...
    (microsoft.public.access.security)
  • Re: i give up...please tell me how to remove security
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > When I copied the database over I also copied the "secured.mdw" file and ... > shortcut that I used to open it. ... I changed the workgroup in the target of the shortcut to refer to this ...
    (microsoft.public.access.security)
  • Re: Access 2000
    ... I have created and then logged in under the workgroup WRKGRP on my system, ... copied their secured.mdw file to my system, and given my shortcut the same ... > The database is probably secured. ... "You do not have the necessary permissions to ...
    (microsoft.public.access.security)
  • Re: User and Workgroup was screwed
    ... We have a Access database for logging all the activities we do everyday. ... If you use a shortcut, right-click the shortcut and examine the Target property; ... Make sure the .mdw file is in the path specified. ... If you don't use a shortcut to open your db, then the machine was probably "joined" to a workgroup. ...
    (microsoft.public.access.security)
  • RE: Workgroup Security
    ... I have moved database file, and setup new mdw but, ... shortcut, as shown below, opens database with usergroup set to system.mdw ... I have created a shortcut as follows: ...
    (microsoft.public.access.security)