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.

You can use the OpenDataAccessPage macro action to open a data access page in Page view or Design view.

Note: Access 2007 is the last version that supports opening data access pages.

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


The OpenDataAccessPage macro action has the following arguments.

Action argument


Data Access Page Name

The name of the page to open. The Data Access Page Name box in the Action Arguments section of the Macro Builder pane shows all pages in the current database. This is a required argument.

If you run a macro containing the OpenDataAccessPage macro action in a library database, Microsoft Office Access 2007 first looks for the page with this name in the library database, and then in the current database.


The view in which the data access page will open. Click Browse or Design in the View box. The default is Browse.


This action is similar to double-clicking the data access page in the Navigation Pane, or right-clicking the data access page in the Navigation Pane and then clicking Design View.

To run the OpenDataAccessPage macro action in a Visual Basic for Applications (VBA) module, use the OpenView 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?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!