Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


Determines if you can write to a table. This function can test for both full write permission and partial write permission that has been granted with a security filter. A write permission consists of Insert, Delete, and Modify permissions.




Type: Record

A record in the table from which you want to determine if you have write permission.

Type: Boolean

Specifies whether you have permission to write to the table using any of the following record functions:

true if you can write to some or all of the table. false if you cannot write to the table.

This function uses the filter that is currently applied to the Record to determine whether you have write permission. If no filter is applied, the function tests for full write permission. If a filter has been set, the function only tests for write permission within the range of the filter.

To determine whether the user has a partial read permission, because a security filter has been applied, use the SETPERMISSIONFILTER Function (Record) before testing the permission with WRITEPERMISSION.

If you do not have permission to write to a table and you attempt to write, a run-time error occurs. This function allows you to determine in advance if you have write permission. When the permissions are checked, the combination of permissions in the license file and the user's permissions in the Permission table is considered.

Community Additions

© 2015 Microsoft