PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Access (Property)
In french: Accès
ODBCHFSQLNot available with these kinds of connection
..Access is used to manage the type of access for 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.
Note: The connection can correspond to:
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Note: 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 name>..Access
<Type of access>: Integer constant
Returns the type of access for the connection:
hOReadWriteThe 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.
hOReadThe 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.
OLE DB This constant is available during an OLE DB connection only.
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:

Defining the type of access for a connection Hide the details

<Connection name>..Access = <Type of access>
<Connection name>: Character string (with or without quotes)
Name of connection used. This name was defined:
<Type of access>: Integer constant
Defining the type of access for a connection:
hOReadWriteThe 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.
hOReadThe 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.
OLE DB This constant is available during an OLE DB connection only. It is ignored in the other cases.
Remarks
..CtAccess is used to define the type of access on a data file handled by a connection. This property is kept for backward compatibility. We recommend that you use ..Access.
Caution: ..Access only applies to a "Connection" type. ..CtAccess applies to a data file.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment