Do you really need 3 calls to the msaccess.exe file? You might be able to open the second and third DBs from the same instance of Access - not sure, but it's an idea to look into.
Richard --- In [email protected], john sayre <[EMAIL PROTECTED]> wrote: > They are, unfortunately, dependent on each other. Access 1 feeds 2 feeds 3. > > "Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote:Will it run from the scheduler or Unix if you only have a single Access > call? You might try making three separate batch files, and run them > five minutes apart from each other. > > I know that my computer here hangs or does funny things if I open a > second database while I have one already open, and this batch file is > probably trying to get all three open at nearly the same time. > > Tobi > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of bitschon > Sent: Thursday, September 29, 2005 3:33 PM > To: [email protected] > Subject: [AccessDevelopers] Run Batch That Kicks off Access hangs > > > This simple batch file is supposed to open and run three Access DBS > and create PDFs: > > "C:\Program Files\Microsoft Office\Office10\msaccess.exe " > c:\daily_sls\Store_Stats\Weekly_Stats_rpt.mdb > "C:\Program Files\Microsoft Office\Office10\msaccess.exe " > c:\daily_sls\Store_Stats\MTD_Stats_rpt.mdb > "C:\Program Files\Microsoft Office\Office10\msaccess.exe " > c:\daily_sls\Store_Stats\YTD_Stats_rpt.mdb > exit > > If I double click it, it runs fine, but if I run through the MS > Scheduler or call from Unix script, it hangs when it opens the first > Access.exe > > > Is there a way around this? > > Thanks > JPS > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AccessDevelopers" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
