AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / 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
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Native Access Connector
Conectores NativosDisponible solo con este tipo de conexión
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 "Análisis" tab, in the "Creación" group, expand "Importar" 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 files can be handled by the functions for managing data files (starting with the letter H).
Native Access Connector with WINDEV 5.5. What to do with a new WINDEV version?
WINDEVConectores Nativos 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.
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 24/03/2025

Señalar un error o enviar una sugerencia | Ayuda local