The
CtAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB. You can:
- Get the type of access to the data file used to connect to a table via OLE DB.
The type of access can correspond to:- the type of access defined in the data model editor,
- the type of access specified in HConnect, HDescribeConnection or HOpenConnection.
This property can be used for a data file or for a connection defined in the data model editor or through programming.
- Define the type of access to the data file used for connecting to a table via OLE DB (when programmatically describing the data file only).
In this case, this property is equivalent to the CtDescribedAccess property.
Reminder:
HConnect is used to redefine one or more parameters of the OLE DB connection to a table. By default, the characteristics of the OLE DB connection are defined:
- in the data model editor during the description of the data file,
- when the data file was described through programming.
// Find out the type of access to the Customer data file
ResAccessType = Customer.CtAccess
Syntax
Finding out the type of access to the data file by a connection Hide the details
<Type of access> = <Data file or Connection>.CtAccess
<Type of access>: Constant
Returns the type of access to the data file. | |
hORead | The data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted. |
hOReadWrite | The data file can be accessed in read/write. You have the ability to read the records and to write new records. |
<Data file or Connection>: Character string
Defining the type of access to the file by a connection Hide the details
<Data file or Connection>.CtAccess = <Type of access>
<Data file or Connection>: Character string
<Type of access>: Constant
Defines the type of access to the data file. | |
hORead | The data file can be accessed in read-only. You only have the ability to read the records. No record can be added or deleted. |
hOReadWrite | The data file can be accessed in read/write. You have the ability to read the records and to write new records. |
Remarks
Miscellaneous
The
CtDescribedAccess property is used to get and change the type of access specified for the OLE DB connection when describing the data file.
Equivalence
The
CtAccess property is used to define the type of access to a data file handled by a connection. This property is kept for backward compatibility. It is recommended to use the
Access property. The
Access property is used to define the type of access to the data files handled by a connection.