Re: Batch File from Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Beverly76 (Beverly76_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 11:41:03 -0700

Thanks everybody. The shell command did work, once I found it.

"Dan Artuso" wrote:

> Hi,
> Look up Shell in Help.
> It give you the syntax and a sample code snippet.
> That's all you need to run your batch file.
>
> --
> HTH
> Dan Artuso, Access MVP
>
>
> "Beverly76" <Beverly76@discussions.microsoft.com> wrote in message news:3D487FA0-E1E5-420A-BA46-41A71F3693A4@microsoft.com...
> > Upon opening an access database, I need to update certain dbf files. I tried
> > to use Visual Basic Code - the code worked on other files but not the ones I
> > need. It seems like there was a security issue I didn't know how to get
> > around. I wrote a batch file to do the same thing which works fine. I would
> > like for Access to run the batch file when the Database is opened (using a
> > switchboard).
> > --
> > Sincerely,
> > Beverly76
>
>
>

Relevant Pages

  • RE: Run batch file through a Access GUI
    ... Then all you have to do is run the Shell command picking up the value of the ... just putting the batch file name in the listbox and building the rest in the ... I presume it contains the Command Lines to install the printers such ...
    (microsoft.public.access.modulesdaovba)
  • how to get vba to wait until a shell command has completed
    ... I'm using a batch file "catff.bat" to concatenate a bunch of files. ... Catff.bat is called from Word using the shell command, ... macro will go into an infinite loop. ...
    (microsoft.public.word.vba.general)
  • problem calling a batch file (.bat) from Shell command
    ... is only call a Shell command which is calling a batch file. ... For some reason ...
    (microsoft.public.vb.enterprise)
  • Re: directory listing, mp3 files
    ... I have to shell a new comand prompt then pass the code one line at a ... Since Shell can only process one command line, ... probably execute the batch file from the Shell command and, ... argument to the Shell command, pass in the appropriate text strings for the ...
    (comp.lang.basic.visual.misc)
  • Re: VB6 and Shell
    ... I'd use VB to call a batch file that calls the command. ... > waitforsingleobject to FORCE VB to wait for completion of the external ... > The shell command seems to run the external program asychronously as you ... Is there away to leave the DOS box open ...
    (microsoft.public.vb.general.discussion)