PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → MS Access database with extension other than mdb
MS Access database with extension other than mdb
Iniciado por guest, 06,nov. 2017 12:18 - 1 respuesta
Publicado el 06,noviembre 2017 - 12:18
Hi there,

For one of my projects I have an access database with an extension gxp not mdb, I tried to connect to it but impossible, when i change the extension to mdb the connection works perfectly. The issue here is I need to keep the extension gxp.
Is there any workaround for that. I use native access SQLConnect and SQL commands.

Thanks in advance.
Publicado el 06,noviembre 2017 - 20:50
Hi

First, you have to put association link to yourAccessFileIn.gxp with msaccess.exe on windows workstation ie whenever doubleClick .gxp will open it up from access.

Then use

trace(HConnect("*", "", "", ...
"c:\yourAccessFileIn.gxp", hAccessHF7, hOReadWrite))

if you see 1 (true) ie connection is made and apply whatever function you
need to access file in that database.

You'd better create a project that can read all files so that you can
use .wdd with HOpenAnalysis(0...

HTH

King