Hi Al,

What message do you get back when you do the second sqlexec ?

>VFP5.0a:
>
>I'm using SQLSTRINGCONNECT() to create a DSN-less connection to an .MDB. Once connected, I can run the first of the following commands successfully, but not the second (it returns -1):

=SQLEXEC(nHandle, "SELECT * FROM <i>Table</i>", "Output")
>=SQLEXEC(nHandle, "SELECT <i>OneField</i> FROM <i>Table</i>", "Output")

The first command works fine but pulls across fields I don't need, and all the character fields are 150 in length so the cursor is pudgy & pokey. I can't for the life of me see why * would work, but a single field won't.
>
>???