Controlling read/write access to a table
Go Up to Working with Tables
By default when a table is opened, it requests read and write access for the underlying database table. Depending on the characteristics of the underlying database table, the requested write privilege may not be granted (for example, when you request write access to a SQL table on a remote server and the server restricts the table’s access to read only).
The ReadOnly property for table components is the only property that can affect an application’s read and write access to a table.
ReadOnly determines whether or not a user can both view and edit data. When
ReadOnly is False (the default), a user can both view and edit data. To restrict a user to viewing data, set
True before opening a table.