AcOpenDataMode Enumeration (Access)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the data entry mode when opening a table, query, stored procedure, view, or user-defined function.

Name

Value

Description

acAdd

0

The user can add new records but can't view or edit existing records.

acEdit

1

The user can view or edit existing records and add new records.

acReadOnly

2

The user can only view records.

Show: