I use ODBC and remote views to MS Access tables. Works great.

>I can do this much, which gets me a list of the tables in a chosen .MDB file stuck into the ACCTABLES cursor.
>My goal is to be able to add records to the customer table in the open database, but I guess my SQLEXEC function isn't the way to go about it...
>How far off am I?
>
>sh = SQLCONNECT() && Will ask me what I want to connect to
>retval = SQLSETPROP(sh, 'Asynchronous', .F.)
>retval = SQLTABLES(sh, "TABLE", "ACCTABLES")
>retval = SQLEXEC(sh, [INSERT INTO Customer (firstname, lastname) VALUES ("first_name", "last_name")] )
>
>retval = SQLEXEC(sh, "SELECT * FROM Customer", "custcopy")
>
>SELECT custcopy
>BROW && And it's still empty!
>
>What should I be doing?
>
>Thanx!