vba to close another database.

[shutzy]

i want to start automating a few things in my database. i have recently discovered task scheduler which will allow me to open a file, program etc. however it wont let me close an open file, program etc. so i am building another database to open via the schduler, close the other open database and then close itself.

the reason for this is that i want to have the automated tasks in my main database to run on open. so after the dummy DB has run and close i plan on opening the main database through task scheduler and putting the code to do the automated tasks behind the main screen that opens automatically.

so i need to know how to close a database from another database.

any help or other suggestions on how to do this are very welcome.

thanks