Kevin,

What ODBC error you get ( AERROR() ) ?

>I am using the following code to connect to my DBC. Pretty straightforward....
>
>

>
>lcDB = "C:\TTS\DBFS\tts.dbc"
>lcConnectString = "Driver={Microsoft Visual FoxPro Driver};" + ;
>		  "SourceType=DBC;SourceDB=" + lcDB + ";" + ;
>		  "Exclusive=No;NULL=NO;Collate=Machine;" + ;
>		  "BACKGROUNDFETCH=NO;DELETED=NO"
>
>lnStringConnection = SQLStringConnect(lcConnectString, .T.)
>?lnStringConnection  && returns 1
>
>lnConnection = SQLCONNECT(lnStringConnection)
>?lnConnection && returns 2
>
>

>
>I have 3 tables that were added to the dbc a couple of months ago. If I try a SQLExec to one of these new tables, it will not connect. It will connect to any of the tables that were there previously:
>
>

>* old table
>lsSql = "SELECT * FROM employee"
>lnSuccess = SQLExec(lnConnection, lsSql, "tProcess")
>?lnSuccess  && returns 1
>
>* one of the new tables
>lsSql = "SELECT * FROM reserve"
>lnSuccess = SQLExec(lnConnection, lsSql, "tProcess")
>?lnSuccess  && returns -1
>