Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

In an Access project (*.adp), you can use the OpenDiagram macro action to open a database diagram in Design view.

Note: This action will not be allowed if the database is not trusted.

Note: Access 2010 is the last version that supports Access data projects.


The OpenDiagram macro action has the following argument.

Action argument


Diagram Name

The name of the database diagram to open. The Diagram Name box in the Action Arguments section of the macro design window shows all database diagrams in the current database. This is a required argument.

If you run a macro containing the OpenDiagram action in a library database, Access first looks for the diagram with this name in the library database, and then in the current database.


This action is similar to double-clicking a database diagram in the Navigation Pane, or right-clicking the database diagram in the Navigation Pane and then clicking Design View.


You can drag a database diagram from the Navigation Pane to the macro design window. This automatically creates an OpenDiagram action that opens the database diagram in Design view.

To run the OpenDiagram macro action in a Visual Basic for Applications (VBA) module, use the OpenDiagram method of the DoCmd object.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!