ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 MS Access or Internet Explorer 6.0 for example).
Note: The Access Native Connector works with Access 2007 and higher (files in ACCDB/MDB format)..
Creating an application that uses a Native Access Connector
To create an application that uses 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 Load project analysis 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 data files (starting with the letter H). A connection to the Access database is automatically established.
Note: if the path of the Access tables used is different during development and when the application is run, use the HChangeDir and HChangeName functions.
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 data files can be manipulated by data file management functions (functions beginning 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: 01/11/2025

Send a report | Local help