Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: using batch file

Geek News

using batch file
JohnE 12/18/2008 6:49:02 PM
On each user's machine is a copy of the mde front end. To open it, the user
double clicks an icon. Eventually the icon will be a batch file that will
run some processes and then finally open the mde file that is located on
everyone's machine. But, the batch file is not working properly in that an
"Automation error" appears just as the mde opens. I have traced it thru to
the line below (I've changed companyname to protect the innocent - or stupid).

START "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Program
Files\companyname\corporate database\corporate database front end 2003.mde"
/wrkgrp "\\MXShared\Database$\companyname.mdw"

All of the information on the line above is correct as far as location.
This line is the target line of the current icon that is used.

If someone who knows batch files sees what's wrong, let me know.

Thanks.
.... John
Re: using batch file
"Stuart McCall" <smccall[ at ]myunrealbox.com> 12/18/2008 7:06:59 PM
"JohnE" <JohnE[ at ]discussions.microsoft.com> wrote in message
news:5C805FE0-D888-4934-8E0C-9EDD23AF04DA[ at ]microsoft.com...
[Quoted Text]
> On each user's machine is a copy of the mde front end. To open it, the
> user
> double clicks an icon. Eventually the icon will be a batch file that will
> run some processes and then finally open the mde file that is located on
> everyone's machine. But, the batch file is not working properly in that
> an
> "Automation error" appears just as the mde opens. I have traced it thru
> to
> the line below (I've changed companyname to protect the innocent - or
> stupid).
>
> START "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> "C:\Program
> Files\companyname\corporate database\corporate database front end
> 2003.mde"
> /wrkgrp "\\MXShared\Database$\companyname.mdw"
>
> All of the information on the line above is correct as far as location.
> This line is the target line of the current icon that is used.
>
> If someone who knows batch files sees what's wrong, let me know.
>
> Thanks.
> ... John

Well the syntax and placement of quotes is all correct AFAICS. Try removing
the START command from the beginning of the line.


Re: using batch file
JohnE 12/18/2008 7:25:01 PM
It worked! So simple.
Thanks.
.... John



"Stuart McCall" wrote:

[Quoted Text]
> "JohnE" <JohnE[ at ]discussions.microsoft.com> wrote in message
> news:5C805FE0-D888-4934-8E0C-9EDD23AF04DA[ at ]microsoft.com...
> > On each user's machine is a copy of the mde front end. To open it, the
> > user
> > double clicks an icon. Eventually the icon will be a batch file that will
> > run some processes and then finally open the mde file that is located on
> > everyone's machine. But, the batch file is not working properly in that
> > an
> > "Automation error" appears just as the mde opens. I have traced it thru
> > to
> > the line below (I've changed companyname to protect the innocent - or
> > stupid).
> >
> > START "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> > "C:\Program
> > Files\companyname\corporate database\corporate database front end
> > 2003.mde"
> > /wrkgrp "\\MXShared\Database$\companyname.mdw"
> >
> > All of the information on the line above is correct as far as location.
> > This line is the target line of the current icon that is used.
> >
> > If someone who knows batch files sees what's wrong, let me know.
> >
> > Thanks.
> > ... John
>
> Well the syntax and placement of quotes is all correct AFAICS. Try removing
> the START command from the beginning of the line.
>
>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net