Getting a batch file to point to a work group

[Beth Gardner]

I have client front end databases that are updated
automatically to new versions via a batch file. I have
recently secured this database and need to have this batch
file point to the proper work group file. Here is the
code for the batch file that I have currently. The START
line at the bottom is what I tried to do to point to the
batch file, but it doesn't work. Can someone please tell
me how to write this?

@echo off

if not exist "\\EMCDM3\home\ACCESS\Secure_APV073103.mdb"
goto getdb:

goto startdb

:getdb

md "\\EMCDM3\home\ACCESS\" >nul

del "\\EMCDM3\home\ACCESS\Secure_APV*.mdb" >nul

copy H:\Finance\AP\Db\Secure_APV073103.mdb "\\EMCDM3
\home\ACCESS\" >nul

:startdb

START "c:\Program Files\Acc97
\Office\msaccess.exe" "\\EMCDM3
\home\ACCESS\Secure_APV073103.mdb" "/wrkgrp
H:\FINANCE\AP\ACCESS\Databases\system.mdw"

@CLS

@EXIT

Thanks a million!

Beth G

 

[Joan Wild]

START "c:\Program Files\Acc97
\Office\msaccess.exe" "\\EMCDM3
\home\ACCESS\Secure_APV073103.mdb" "/wrkgrp
H:\FINANCE\AP\ACCESS\Databases\system.mdw"

You have a misplaced double quote. There should be no double quote in front
of /wrkgrp, but instead in front of H:\FINANCE....