I have two different DBExec that I am running. I wrote the first one. It writes to an Access DB. It is successful, and the result=1. I wrote the second DBExec. It is writing to Pervasive. It is also successful, and the result=0. Can someone explain the result value?

Thank you! That worked. The dbH=1. That I did not know. That will help a lot. Thanks again!

Let>connstr=Driver={Microsoft Access Driver (*.mdb)};Dbq=k:\Write to GS.mdb;Uid=Admin;Pwd=; DBConnect>connstr,dbH Let>SQL=SELECT Job FROM Write to GS DBQuery>dbH,SQL,rsPart,numRecs,numFields DBClose>dbH I'm trying to write a macro to return fields from an Access table. I've done this with another SQ...