ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL
  • Overview
  • Operations required to run Native Access Connectors in WINDEV and WEBDEV
  • Creating an application that uses a Native Access Connector
  • Native Access Connector with WINDEV 5.5. What to do 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 Access Connector
Native Connectors (Native Accesses)Available only with this kind of connection
Overview

Operations required to run Native Access Connectors in WINDEV and WEBDEV

This type of Native Connector allows access to ACCESS databases for better interoperability purposes. We recommend that you use HFSQL, the database engine included in WINDEV and WEBDEV.
To use a Native Access Connector, you need to install:
  • MDAC.
  • the Microsoft Jet provider (installed with Access or Internet Explorer 6.0 for example).
Remark: Native Access Connectors are available in Access 2007 and later (ACCDB and MDB files).
Creating an application that uses a Native Access Connector
To create an application using Access tables, import the structure of these tables into the WINDEV or WEBDEV data model editor:
  1. Open the analysis associated with the project: click Load project analysis in 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 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 differs during the development and when running the application, use 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).
Native Access Connector with WINDEV 5.5. What to do with a new WINDEV version?
WINDEVNative Connectors (Native Accesses) In WINDEV 5.5, SQLConnect allowed you to use the Native Access Connector. 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

Last update: 06/13/2023

Send a report | Local help