Batch File Problem

[Bob Darlington]

I want to run the following batch file from Scheduler each night from a
command line:
'm:\dpc data\createbackup.bat'

The batch file is simply:
ECHO Off
Start createbackup.mdb

where 'createbackup.mdb' (which resides in 'm:\dpc data') compacts and
repairs the file into a temp folder and returns it to its original location.

It does exactly what I expect, except that the following Windows error is
generated immediately after the second line of the batch file is executed -
ie after the mdb is successfully finished:
'Windows cannot find 'M:\dpc data\createbackup.mdb' etc etc
If I insert MsgBox "Done", immeditaely before DoCmd Quit in my mdb, then
this message box appears and when acknowledged the program completes without
the above error.
I need the batch to run without user intervention at 1am each morning, so
the error msg is causing a problem.
Any help appreciated.

Bob

[Arno R]

Bob,
Is it so that your mdb is trying to copy the new file to it's original locaton while it's not ready
compacting yet?
If so, try to 'dir' until it's there?

Without more info on your code it's difficult to guess what's causing your problem.

--
Hope this helps
Arno R

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht
news:3f***********************@news.optusnet.com.a u...

I want to run the following batch file from Scheduler each night from a
command line:
'm:\dpc data\createbackup.bat'

The batch file is simply:
ECHO Off
Start createbackup.mdb

where 'createbackup.mdb' (which resides in 'm:\dpc data') compacts and
repairs the file into a temp folder and returns it to its original location.

It does exactly what I expect, except that the following Windows error is
generated immediately after the second line of the batch file is executed -
ie after the mdb is successfully finished:
'Windows cannot find 'M:\dpc data\createbackup.mdb' etc etc
If I insert MsgBox "Done", immeditaely before DoCmd Quit in my mdb, then
this message box appears and when acknowledged the program completes without
the above error.
I need the batch to run without user intervention at 1am each morning, so
the error msg is causing a problem.
Any help appreciated.

Bob

[Bob Darlington]

Thanks Arno,
No, the error occurs after the program has done everything. ie just before
DoCmd.Quit.

--
Bob Darlington
Brisbane
"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...

Bob,
Is it so that your mdb is trying to copy the new file to it's original locaton while it's not ready compacting yet?
If so, try to 'dir' until it's there?

Without more info on your code it's difficult to guess what's causing your problem.
--
Hope this helps
Arno R

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht
news:3f***********************@news.optusnet.com.a u...

I want to run the following batch file from Scheduler each night from a
command line:
'm:\dpc data\createbackup.bat'

The batch file is simply:
ECHO Off
Start createbackup.mdb

where 'createbackup.mdb' (which resides in 'm:\dpc data') compacts and
repairs the file into a temp folder and returns it to its original location.
It does exactly what I expect, except that the following Windows error is generated immediately after the second line of the batch file is executed - ie after the mdb is successfully finished:
'Windows cannot find 'M:\dpc data\createbackup.mdb' etc etc
If I insert MsgBox "Done", immeditaely before DoCmd Quit in my mdb, then this message box appears and when acknowledged the program completes without the above error.
I need the batch to run without user intervention at 1am each morning, so the error msg is causing a problem.
Any help appreciated.

Bob

[Arno R]

Bob,
If I understood you well then you said when you insert a msgbox "Done"
before docmd.Quit you have no problem?
Hence it still seems to me that Access is not finished with 'something'.
Again: Without more info on your code it's difficult to guess what's causing your problem.
--
Hope this helps
Arno R

[Pieter Linden]

"Arno R" <ar****************@tiscali.nl> wrote in message news:<3f**********************@dreader2.news.tisca li.nl>...

Bob,
If I understood you well then you said when you insert a msgbox "Done"
before docmd.Quit you have no problem?
Hence it still seems to me that Access is not finished with 'something'.
Again: Without more info on your code it's difficult to guess what's causing your problem.

Is this the "Access is executing steps asynchronously" trap? If so,
you may need ShellAndWait or a DoEvents command in there to allow the
copying or whatever to finish before you continue your code execution.
Heck, you could throw in a WAIT [n] command or something and which
would allow the other process to finish before finishing the series of
steps.

[Bob Darlington]

Thanks Pieter,
The wait routine (5 secs) did the trick nicely.

--
Bob Darlington
Brisbane
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"Arno R" <ar****************@tiscali.nl> wrote in message news:<3f**********************@dreader2.news.tisca li.nl>...

Bob,
If I understood you well then you said when you insert a msgbox "Done"
before docmd.Quit you have no problem?
Hence it still seems to me that Access is not finished with 'something'.
Again: Without more info on your code it's difficult to guess what's

causing your problem.

Is this the "Access is executing steps asynchronously" trap? If so,
you may need ShellAndWait or a DoEvents command in there to allow the
copying or whatever to finish before you continue your code execution.
Heck, you could throw in a WAIT [n] command or something and which
would allow the other process to finish before finishing the series of
steps.