Is there a command line I could put on a desktop icon to quickly change
which workgroup I am joined to?
Thanks in advance.

Kathy,

No, but you should join workgroups only while working in those applications
that require them. Create a shortcut to a secured database. Right-click the
shortcut, and select Properties. In the Target field, enter the following:
    "path to msaccess.exe" "path to database.mdb" /wrkgrp "path to mdw"

Make sure to enter the exact paths. Click OK. Then double-click the
shortcut, and you'll see the database's Login dialog appear. Enter your
username and password, and that's it - you're in.

Repeat this process for all secured databases.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Show quoteHide quote

New Post - Owner deleted - No backups, nothing!
Security in fields
Re: User and Workgroup was screwed
Preventing design changes with share-based security
Workgroup file in Network drive and Local computer
Creating a workgroup
Detecting user with blank password?
Exclusive Access Message.........
Hiding database window
In Security, Workgroup Administrator Add Check Box to always point