Get(RecordAccess)

Category: Get

Syntax: Get ( RecordAccess )

Parameters: None

Data type returned: Number

Description:

Returns a number that represents the current account's access privileges for the current record. Record privileges are assigned via privilege set.

Returns 0 if the user does not have View or Edit privileges for the current record.

Returns 1 if the user has view-only access to the current record. This could mean the View is set to Yes for the current table, or that View is set to Limited and that the calculation defined for Limited access returns a value of True.

Returns 2 if the user has edit access for the current record. This could mean that Edit is set to Yes for the current table, or that Edit is set to Limited and that the calculation defined for Limited access returns a value of True.

The Get (RecordAccess) function can be used to alert users of restricted privileges at the record level. Note that Get (RecordAccess) returns information only about table record privileges. Record access may be restricted through the layout access as well.

To fully evaluate current record access, evaluate both the return values of Get (LayoutAccess) and the Get (RecordAccess) function.

Examples:

Function	Results
Get ( RecordAccess )	Returns 1 if a user can view, but potentially not edit, a given record.