Hello, I am a newbie, apologies if this has already been covered. I am trying to use Windows Command batch to loop through all files within a folder. I have seen on another thread where within the loop - for each file Monarch is opened and processes each file. I am having an issue where I am trying to export and append to the same Microsoft Access file (.mdb). What happens is that when Monarch adds to the mdb file it temporarily locks out the file for editing. Even though I run the same script, different amounts of data are appended to the database each time. How do I got about resolving the issue? Ideally I would only want to call Monarch once and then have a loop to open all reports within the same folder at once and once that loops is done add to and append to my mdb. Any help is appreciated, Thanks!
Current expression:
for %i in ("d:\etc\etc\*.doc") do "C:\Program Files (x86)\Monarch\Program\Monarch.exe"/rpt:"%i" /mod:"d:\etc\etc.xmod" /expfileopt:add /exp:"d:\etc\etc.mdb" /exptableopt:append /exptable:"Newtable" \T
