Re: Batch File from Access

From: Lance McGonigal (lancemcgoi_at_msn.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 13:40:20 -0500

Well, if you want to run a batch file (mybatch.bat) then use the shell
command. If you get errors for security reasons then you need to speak with
your net admin. The shell works for me.

"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