Automation

[nath]

Hi,

I have two databases, the one copies a file structure and
places spreadsheets in that file structure. the second
uses those files to generate reports. However one of the
files is the second database.

When i open the database that creates the structure and
puts the files in place, i have written code to look for
a "cookie" file to see if it has been accessed by
automation. If it has, then it runs the structure
creation procedure. In the code that opens this database,
after the opening, i have put.

docmd.quit

to close the database, so it can be copied. Then the 2nd
re-opens it.

The problem i have is that before the db has closed the
copying process in going. I believe that it swithces to
the 2nd DB, therefore halting the 1st's code, do the .quit
function is not executed.

I need the 1st to quit before the 2nd starts running.

Can anyone help?

 

[Dev Ashish]

The problem i have is that before the db has closed the
copying process in going. I believe that it swithces to
the 2nd DB, therefore halting the 1st's code, do the .quit
function is not executed.

I need the 1st to quit before the 2nd starts running.

You'll have to post the relevant portions of code.

-- Dev