RE: [AccessDevelopers] Run Batch That Kicks off Access hangs

Thu, 29 Sep 2005 13:44:46 -0700

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.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to