Automation

  • Thread starter Thread starter nath
  • Start date Start date
N

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?
 
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.
Click to expand...

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

-- Dev
 
Back
Top