Join Workgroup file in A2007

[Anand]

Hi,
Am using A2k app with user level security. Workgroup file with the user
details resides in a server.

Recently installed A2007 in a computer and want to connect the A2k app
running on this machine to the workgroup file in the server. How do I tell
A2007 to connect to the workgroup file sitting in the server? Could find the
user security wiz and permissions menu when A2k app is opened in A2007. The
user sec wiz creates a new wrkgrp file - which I dont want. The permissions
menu takes me to the default user list and not to the wrkgrp file in the
server.

TIA
Anand

 

[Tom van Stiphout]

On Tue, 12 Jan 2010 00:59:01 -0800, Anand

Create a shortcut to run the app like this:
<path_to>msaccess.exe <path_to>your.mdb /wrkgrp <path_to>your.mdw

-Tom.
Microsoft Access MVP

 

[Mrs. Ugh]

Anand-
Whenever I need to get someone in to a secured database, I put a shortcut on
their desktop that connects them to the associated workgroup. The shortcut
"Target" contains the following:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\Folder1\Subfolder1\DatabaseName.mdb" /user "UserNameHere" /WRKGRP
"I:\FolderA\SubfolderA\WorkgroupName.mdw"
where I: is the server location. Just change the locations to match your
situation.
Jill