Question about security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create a database and had this database shared in a server, because I need
several people using that with different security levels. Security was
created using the User-Lever Security Wizard.

The question is: How can I share the security workgroup created in the
server?, so I don't need to create the workgroup and security again in every
PC. Is this workgroup created in a file that can be share or even copy and
paste the file.

I will greatly appreciate your help.

Thank you.
 
jeannette_rivera said:
I create a database and had this database shared in a server, because I
need
several people using that with different security levels. Security was
created using the User-Lever Security Wizard.

The question is: How can I share the security workgroup created in the
server?, so I don't need to create the workgroup and security again in
every
PC. Is this workgroup created in a file that can be share or even copy
and
paste the file.
Click to expand...
I've never used the wizard but the setup is this:

*All* Access databases need a Workgroup Information file (WIF) in order to
open. By default this file is called "system.mdw" and resides somewhere on
the drive where you installed Office.

When you apply user-level security you *should* create a new WIF (*.mdw)
which, for multi-user access you would normally store in a public folder
somewhere on a network where all your users can see it.

I'm not sure if the wizard creates a new WIF (it should really IMO) or
modifies the default one, but either way, the WIF is what you should be
putting onto the server. Your users would then switch to it at run-time
using a desktop shortcut in the format:

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"

including the quotation marks.

HTH - Keith.
www.keithwilby.com
 
Hi Keith:

Looks like this is what I need but I'm not sure what is the information to
be included in the path "Full path to MSACCESS.exe" "Full path to your
app.mdb" /wrkgrp "Full path to your WIF.mdw"

Can you give me an example. I feel very stupid trying to figure out what
information to include.

I appreciate your help and if this work you have save my life. You're a
sunshine.

Thanks.
 
Looks like this is what I need but I'm not sure what is the information to
be included in the path "Full path to MSACCESS.exe" "Full path to your
app.mdb" /wrkgrp "Full path to your WIF.mdw"

Can you give me an example. I feel very stupid trying to figure out what
information to include.
Click to expand...


PMFJI! On my computer it would look something like this:

"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"C:\SomeFolder\MyDatabase.mdb" /wrkgrp "F:\SomeFolder\Workgroup.mdw"

Obviously, you will need to change the folder locations for all that
depending on your setup.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Adding to Lynn's reply:

If you don't know the path to Access, just Start : Find "msaccess.exe"
(without the quotes).

If you don't know the path to your database, just open the folder
containing it, then copy the path from the address box at the top of
that window.

HTH,
TC
 
Sorry to gave you a hard time with this.

You help me a lot and I really appreciate your help.

Jeannette
 
Back
Top