2002-Shortcut will not set Workgroup info file

[Mike M]

We have multiple Access 2002 applications and we need to
create desktop shortcuts for each application so that the
proper security will be applied.

An example of one of our shortcuts is as follows:

J:\ISSTART-A2002\ISSTART-A2000B.mdb /wrkgrp "J:\ISSTART-
A2002\SYSTEM.mdw" /Nostartup

The shortcuts are not joining their workgroup - instead,
it is using the one that is currently set by using the
workgroup administrator to join.

Is there something we are missing in the shortcut command?

Thank you

 

[Joan Wild]

You are missing the path to the msaccess.exe.

Since you are using a switch you must supply the path to the executable.

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

Also you can use UNC pathnames, rather than mapped drives, and then not have
to rely on 'J' being mapped correctly.

Your path suggests that you are going to have multiple users accessing the
mdb on a network share. You'd be best to split the application into two -
frontend and backend. Leave the backend on the server and give each user a
copy of the frontend linked to the tables in the backend.

More details can be found in Help.

 

[Mike M]

I now have created the following two shortcuts:
1.
"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "J:\Operations A2002\Secure ID Cards-
A2002.mdb" /WRKGRP "J:\Operations A2002\SYSTEM-IDCARDS-
A2002.mdw" /nostartup

2.
"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "J:\ISSTART-A2002\ISSTART-
A2000B.mdb" /wrkgrp "J:\ISSTART-A2002
\SYSTEM.mdw" /Nostartup

Now, "2." will prompt for username and "1." never prompts
for username and neither are switching to the appropriate
workgroup file.

What are we doing wrong?

Thank you

 

[Joan Wild]

If you get no login dialog, then there is no password set for the built-in
'Admin' user.

When you open 1, go to Tools, security, accounts, and change password tab -
it will show you the current user is Admin - set a password for this user.

Since the Admin user has no password in system-idcards-a2002.mdw you may not
have secured it properly. Follow the steps outlined in the security FAQ
http://support.microsoft.com/?kbid=207793

 

[Mike M]

If I start each shortcut, and the click on tools |
security | Workgroup Adm, both applications are pointing
to the same workgroup file - not their respective
workgroup files that I have specified in the shortcut.

However, the one that was not prompting for a username is
now prompting - once I added a password to the admin. But
how can this be since they both are telling me that they
were using the same workgroup file??

Sorry for the confusion and thank you for your help!!!

 

[Joan Wild]

Using a shortcut does not change your default workgroup file. It just uses
that workgroup file for that session.

Tools, Security, workgroup administrator will always show you the default
workgroup that is set - not the current workgroup in use.

Try your shortcut again; once in go to the debug window (Ctrl-G) and type
?DBEngine.SystemDB

That will show you the mdw in use.

 

[Mike M]

That's exactly the clarification I was needing!

I have verified everything now and it is working fine.

Thank you for sticking with me thru this!

Mike