Workgroup Information File

[Dallas Miller]

Hello,

I have an Access 2002 application where I have created a
workgroup information file. I added some users and tested
it on my machine. When one of the users I setup logs in
from her machine the logon screen is not presented and
she gets into the system as "Admin". Is there a way to
automatically point a user to the security file (.MDE)
out in the server? I do not want to run the security
options manually inorder for the system to see the user.

Any and all help will be greatly appreciated.

Thanks,
Dallas

 

[John Thomas]

Create a shortcut for your users. The shortcut should
contain the following information in its target:

Path to their Access.exe
The workgroup argument
Path to the workgroup info file

Here's an example of the shortcut's target:
"c:\program
files\msoffice\office\msaccess.exe" /wrkgrp "h:\company
databases\security\mydb.mdw"

Obviously, replace everything with your actual paths. Use
quotes whenever a path string has a space in it. Have the
user get into the db using the shortcut only, and
the /wrkgrp option will force them to log into your
security file. If you want to prevent them from
attempting to access the db by launching Access and using
File/Open, that's a whole other story. Suffice it to say
you have to use code in your startup form, open a
workspace, iterate the users in the workspace's users
collection looking for a user name you know will be there
(and won't be in your standard workgroup info file).

 

[Dallas Miller]

John,

Thanks for your quick response. I knew that their way a
way put I could not find the proper startup commandine
option. Thanks again and have a great day.

Dallas

 

[Rick Brandt]

Hello,

I have an Access 2002 application where I have created a
workgroup information file. I added some users and tested
it on my machine. When one of the users I setup logs in
from her machine the logon screen is not presented and
she gets into the system as "Admin". Is there a way to
automatically point a user to the security file (.MDE)
out in the server? I do not want to run the security
options manually inorder for the system to see the user.

If they are logging in without being prompted then they are not using your
workgroup file. If they can get in without using your workgroup file then you
didn't apply security properly. *After* you fix your security so that they are
turned away when using their default workgroup, then you give them a shortcut
that opens your file and specifies your workgroup file as a command line
argument.

"Path to Access" /wrkgrp "Path to MDW" "Path to MDB"

 

[John Thomas]

Oh Poop! Rick is right. I forgot the "Path to mdb" part
of the command line. That's what I get for being a smarty
pants.

 

[Immanuel Sibero]

Hi Dallas

Access User Level Security step by step instructions:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp


Immanuel Sibero