PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Overview
  • Operations required to run the Native Connector Access in WINDEV and WEBDEV
  • Create an application using the Native Connector Access
  • I was using the Native Connector Access with WINDEV 5.5. What should I with a new WINDEV version?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Native Connector Access
Native Connectors (Native Accesses)Available only with this kind of connection
Overview

Operations required to run the Native Connector Access in WINDEV and WEBDEV

The Native Connector (also called Native Access) to ACCESS type databases is provided for interoperability purposes. We recommend that you use HFSQL, the database engine included in WINDEV and WEBDEV.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
In order to use Native Connector Access, it is necessary to install:
  • MDAC.
  • the Microsoft Jet provider (installed with Access or Internet Explorer 6.0 for example).
Remark: The Native Connector Access works for Access 2007 and higher (files in ACCDB/MDB format).
Create an application using the Native Connector Access
To create an application that is using the Access tables, all you have to do is import the structure of these tables into the data model editor of WINDEV or WEBDEV:
  1. Open the analysis associated with the project: click on Analysis icon among the quick access buttons.
  2. On the "Analysis" tab, in the "Creation" group, expand "Import" and select "Import file/table descriptions...".
If you choose to keep the data in Access format, the Access tables can be directly handled by the WLanguage functions for managing the data files (starting with the letter H). A connection to the Access database is automatically established.
Remark: if the path of the Access tables used is different during development and at runtime, use functions HChangeDir and HChangeName.
If you choose to convert the data to HFSQL format, data files in HFSQL format will be created from the structure of Access tables. These HFSQL files can be handled by the functions for managing the data files (starting with the letter H).
I was using the Native Connector Access with WINDEV 5.5. What should I with a new WINDEV version?
WINDEVNative Connectors (Native Accesses) In WINDEV 5.5, to use the Native Connector Access, it was enough to use the SQLConnect function. Once connected to an Access database, all the standard SQL functions allowed you to access and modify the data found in the database.
This operating mode is kept in the later versions of WINDEV.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment