RE: Workgroup Security

Yes, it is the same proceedure as previously discussed. If you haven't read
already, make sure you keep a backup copy of your mdb because you can't
change the mde.


Best of luck!



"Penstar" wrote:

I was checking the Workgroup Administrator which showed me the system mdw.
But on futher investigation i.e. User and Group accounts it was going to the
correct group.

Thank you so much for you guidance on this one.

One further question... I am going to make an .mde out of this database.
Is it only a matter of supplying the .mdw with the database file, and a
shortcut as discussed above? or are there any further "tricks" that are
required?

Thanks again
Penny

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

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: Security not clicking
    ... Did you start with the original unsecured copy of your database? ... Did you compile and compact the mdb before running the wizard? ... Copy the secure mdw to the server. ...
    (microsoft.public.access.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Pointing to a pointer to an .mdb
    ... shortcut to the batch file. ... Users run the shortcut, the shortcut calls ... the .bat file, the btch file runs the .mdb file, access starts and it ... current database, which is full of valid data, with a new database ...
    (microsoft.public.access.formscoding)
  • Re: More security questions
    ... I have an MDB file that I secured a few weeks back which was working fine. ... I have an MDW file of the same name as the MDB, ... Use a desktop shortcut to launch your secure mdb. ...
    (microsoft.public.access.security)
Loading