ODBC Driver for Act! CRM

Build 26.0.9770

CompanyAccessControl

Query and update the access control level for a company.

Table Specific Information

Select

  • CompanyId supports the '=' operator.
The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:
SELECT * FROM CompanyAccessControl WHERE CompanyId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

SELECT * FROM CompanyAccessControl

Update

Any column where ReadOnly=False can be updated. Specify the CompanyId when updating a company access control record.

UPDATE CompanyAccessControl SET Type = 'Private' WHERE CompanyId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

Columns

Name Type ReadOnly Description
CompanyId [KEY] String True

The unique identifier for the company.

Type String False

Defines the company's access level.

The allowed values are Public, Private, LimitedAccess.

AccessorsAggregate String False

The users or teams that have been granted limited access to the company.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770