Access (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

See also

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:

a connection described in the data model editor,
a connection described by HConnect, HDescribeConnection or HOpenConnection.
a connection described by a Connection variable.

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

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:
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.
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.
This constant is available during an OLE DB connection only.

<Connection>: Character string (with or without quotes) or Connection variable

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Defining the type of access for a connection Hide the details

<Connection>.Access = <Type of access>

<Connection>: Character string (with or without quotes) or Connection variable

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<Type of access>: Integer constant

Defining the type of access for a connection:
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.
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.
This constant is available during an OLE DB connection only. It is ignored in the other cases.

Remarks

The CtAccess property is used to define the type of access on 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 only applies to "Connection" types. The CtAccess property applies to data files.