Solved

Automating wrkgadm.exe

Posted on 2004-10-06
5
268 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:jalvarez86
  • 3
5 Comments
 
LVL 41

Assisted Solution

by:shanesuebsahakarn
shanesuebsahakarn earned 50 total points
ID: 12239891
Why don't you just start up each appropriate database using its correct workgroup file via the /wrkgrp Access command line parameter?
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 75 total points
ID: 12239904
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
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12239920
0
 

Author Comment

by:jalvarez86
ID: 12240014
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
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12240042
afaik the Workgroup Administrator file does not accept command switches, so you're only option is to use shortcuts for each database.  
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now