Workgroup File

[Sho]

I have set up user/ group accounts and assigned
permissions and it all works exactly as I want. The only
problem is that every database I open it comes up with the
user and password box, when I only want this for 1
database, not my other databases. I have tried saving the
workgroup file to the same area as my database, seperate
to all others but I still seem to get this file on my C
drive and I assume that's why it applies to everything
else.

Is there anyway you can apply user/group accounts just to
the one database?

 

[GVaught]

Create a shortcut on the desktop to the computer and set the target path to
call up the workgroup file for that particular database. The path statement
follows this order:
Path to Access.exe path to database /wrkgrp path to workgroup file.
"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Path to db"
/wrkgrp "C:\path to workgroup file.

Then you can join back to the System.mdw file.

 

[Immanuel Sibero]

Hi Sho

Have a look at the following link:

http://support.microsoft.com/support/access/content/secfaq.asp

Anyone implementing Access level security should understand this document in
its entirety. It's an all or nothing proposition meaning that even just a
little lack of understanding could render the security useless. That's why
the MVP's here keep saying to read it at least TWICE, and then...... read it
again for good measure.

All the questions you asked in your post are addressed in the above
document. Have fun.

Immanuel Sibero

 

[Sho]

I have have read the Access FAQ's and tried the shortcut
icon but still it does not work - what am I doing wrong?

I have now created another Access shortcut, right clicked
over it and selected properties. In the Target I have the
following information entered;

"C:\Program Files\Microsoft Office\Office10
\MSAccess.exe" "P:\Ces\Sales\Sales.mdb/wrkgrp" "P:\ces\sale
s\system.mdw"

I have also tried instead of /wrkgrp typing in the
workgroup file ID of sw001wg.

When I run access from this shortcut the username/
password box appears. When I use the normal shortcut it
does not appear until I go to open a different database
and then it still comes up!

It's very frustrating...

-----Original Message-----
Create a shortcut on the desktop to the computer and set the target path to
call up the workgroup file for that particular database. The path statement
follows this order:
Path to Access.exe path to database /wrkgrp path to workgroup file.
"C:\Program Files\Microsoft

Office\Office\MSAccess.exe" "C:\Path to db"