|
| 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 |
| |
| |
| | | |
|
| | | | |
| | |
|