Automating wrkgadm.exe

I can't find anything that says yes or no, but is it possible to pass parameters to wrkgadm.exe so I can script it. Our environment has 3 different workgroups that I'm constantly toggling back and forth between. It ends up being a real drag.

Thanks in advance.
Josh
jalvarez86Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
You do this by creating a shortcut for your application, then right-click:Properties, and in the "Target" textbox create a shortcut path in the following format:

{Location of msaccess.exe} {Location of your application} /wrkgrp {location of app's .mdw file} /user {username} /pwd {password}

UID and PWD are optional.  Surround anything with spaces with double-quote marks.  So...

"C:\Program Files\Microsoft Office\Office10\Msaccess.exe" C:\MyApp.mdb /wrkgrp c:\MyApp.mdw /user me /pwd foo

Hope this helps.
-JIm
0
 
shanesuebsahakarnConnect With a Mentor Commented:
Why don't you just start up each appropriate database using its correct workgroup file via the /wrkgrp Access command line parameter?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
0
 
jalvarez86Author Commented:
While this is correct, and we use this technique for an end-user's shortcuts, it's not quite what I'm looking for.

I want to script the Workgroup Administrator, not Access. I find that as I am working with multiple files in my development environment, I need to switch workgroups. While I _could_ make shortcuts for each database, I really feel that that would be more trouble than it's worth.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
afaik the Workgroup Administrator file does not accept command switches, so you're only option is to use shortcuts for each database.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.