Access (Property) In french: Accès
  Not available with these kinds of connection
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.). You can: - Find out the type of access used for a connection (HFSQL Client/Server, OLE DB, etc.).
- Define the type of access used for the connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently opened, it will be closed then re-opened with the new parameters during a first access to a data file that is using this connection.
Remark: The connection can correspond to:
MyConnection is Connection
// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER"
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hOReadWrite
MyConnection.ExtendedInfo = "Extended information"
MyConnection.CursorOptions = hClientCursor
HOpenConnection(MyConnection)
Syntax
Finding out the type of access for a connection Hide the details
<Type of access> = <Connection>.Access
<Type of access>: Integer constant Returns the type of access for the connection: | | | hORead | The data files handled by the connection can be accessed in read-only mode. You only have the ability to read the records. No record can be added or deleted.
| | hOReadWrite | The data files handled by the connection can be accessed in read/write mode. You have the ability to read the records and to write new records. |
<Connection>: Character string or Connection variable Name of the connection used. This name was defined:
Defining the type of access for a connection Hide the details
<Connection>.Access = <Type of access>
<Connection>: Character string or Connection variable Name of the connection used. This name was defined: <Type of access>: Integer constant Defining the type of access for a connection: | | | hORead | The data files handled by the connection can be accessed in read-only mode. You only have the ability to read the records. No record can be added or deleted.
| | hOReadWrite | The data files handled by the connection can be accessed in read/write mode. You have the ability to read the records and to write new records. |
Remarks 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. Caution: The Access property applies only to "Connection" types. The CtAccess property applies to data files.
This page is also available for…
|
|
|
|