From an Access DB Open another DB so it is not visible and run code in the second DB

[puforee]

I have several Data Bases that need to be updated from the same Excel source file. I want to cause each DB to open an run the update code without showing on the screen. I am using another "Do Updates" DB to trigger each of the data bases to do their updates. This all works except...I would like the updating data bases not to show on the screen. I have triggered "Minimize" when the updating DB's open but the screen still flashes. And, if my DB with the triggering buttons, is on the same screen...the updating DB blanks it out.

Can anyone provide a solution for this. Is there a way to run a DB in the background (not visible).

 

[TwoOdd]

Not sure how complex your update is, but it sounds like you are just updating data in tables across multiple Access databases. If that is the case, one possible solution would be to have your "Do Updates" database create a link to the appropriate table(s) in each of the other databases and update those tables. You could do this one database at a time: create the links, update the linked tables, delete the links. This would eliminate the need to have each database open and close and therefore you would have no additional database windows to hide or minimize during the updating.

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner