WRKGADM.EXE command line options 1

[SeeThru]

Is there any way to issue command line options with WRKGADM.EXE to join a specific workgroup.

I need to reset about 50 PC's. The reccomended method of using an Access command line option to specify the workgroup file is not practical, as I have 200+ databases, and the workgroup file location may change.

Ideally, I'd want to create a batch script that ran on login. Leave it running for a couple of week and all the machines should have the correct one.

Any suggestions other than manually doing each machine?

 

[CautionMP]

SeeThru,
It sounds like it would be easier for you to push a registry update rather than invoking [tt]WRKGADM.EXE[/tt]. Here is an exerpt from Microsoft TechNet Visual Basic Programmer's Guide:
Securing Access Databases:

Note In versions of Microsoft Jet prior to 3.0, the initialization file (usually MSAccess.ini or MSAcc20.ini) is used to store the path and name of the workgroup information file. In Microsoft Jet versions 3.0, 3.5, and 4.0, the path and name of the workgroup information file are stored in the Windows registry. In all versions, the SystemDB registry entry is used to specify the path to the workgroup information file. In Access 2000, the path and name of the default workgroup information file is stored in the \HKEY_LOCAL_MACHINE \SOFTWARE \Microsoft \Office \9.0\Access\Jet\4.0\Engines subkey of the Windows registry.

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[rodrunner79]

Copy and paste this in Notepad and change accordingly. Then save as a .bat file

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\db1.mdb" /WRKGRP "D:\Secured.mdw"

The example above assume that your Database (db1.mdb) is stored in C:\ and your Workgroup (Secured.mdw) file is located in D:\

-=True wisdom comes from knowing you know nothing.=-