Native Access Connector

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

Native xBase/FoxPro Connector

Native Access Connector

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:

Open the analysis associated with the project: click on among the quick access buttons.
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?

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.