>Hello folks,
>
>Scenario:
>
>A VFP8 Win32 executable that reads and updates Access mdb file.
>
>I have the access mdb structure (test file) and have to make VFP exe to read ad write it. This should be done so that I make the VFP exe, send it to my client, nothing else just the exe file (wrapped with ISX for runtime files) and he/she installs it, launch it and this app reads and writes his/her access mdb file.
>
>What would be the preferred way to open/read/update mdb? I would like to use VFP CA but have use it only with VFP natives and haven't see any example how to use CA with above situation.
>
>TIA
>
>AT

SQL Passthrough is a good technique to deal with Access data

use

SQLSTRINGCONNECT() to connect to the data

SQLEXEC() to execute queries and updates against the mdb database

SQLDISCONNECT() then closes the connection to the mdb database