Application.OpenAccessProject method (Access)
Use the OpenAccessProject method to open an existing Microsoft Access project (.adp) as the current Access project in the Access window.
Syntax
expression.OpenAccessProject (filepath, Exclusive)
expression A variable that represents an Application object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
filepath | Required | String | The name of the existing Access project, including the path name and the file name extension. |
Exclusive | Optional | Boolean | Specifies whether you want to open the Access project in exclusive mode. The default value is False, which specifies that the Access project should be opened in shared mode. |
Return value
Nothing
Remarks
The OpenAccessProject method enables you to open an existing project from within Access or another application through Automation, formally called OLE Automation. For example, you can use the OpenAccessProject method from Microsoft Excel to open the Northwind.adp sample database in the Access window. After you have created an instance of Access from another application, you must also create a new Access project or specify a particular Access project to open. This Access project opens in the Access window.
If you have already opened a project and wish to open another project in the Access window, you can use the CloseCurrentDatabase method to close the first Access project before opening another.
Note
To open an Access database, use the OpenCurrentDatabase method of the Application object.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.