You can use the CloseCurrentDatabase method to close the current database (either a Microsoft Access database (.mdb) or an Access project (.adp) from another application that has opened a database through Automation. For example, you might use this method from Microsoft Excel to close the database currently open in the Microsoft Access window before opening another database.
Syntax
application.CloseCurrentDatabase
The CloseCurrentDatabase method has the following argument.
| Argument | Description |
|---|---|
| application | The Application object. |
Remarks
The CloseCurrentDatabase method is useful when you have opened a Microsoft Access database from another application through Automation. Once you have created an instance of Microsoft Access from another application, you must also create a new database or specify an existing database to open. This database opens in the Microsoft Access window.
If you use the CloseCurrentDatabase method to close the database that is open in the current instance of Microsoft Access, you can then open a different database without having to create another instance of Microsoft Access.