You should use AERROR() function to retrieve ODBC error. It may help with troubleshooting.
>I am trying to access Tables in an Access2003 database
>I am using Sqlexec as in:
>lcsqlSelect = "SELECT * from IsPods"
>IF SQLEXEC(lnSqlHandler,lcSqlSelect,"CurTest") = 0
>
>Now, I can access some tables ok and other tables I am getting a -1 result
>I cannot see any pattern
>At first I thouught it might be to do with DateTime field.. but some of the
> ones I can and Cannot access have DateTime fields !!
>
--sb--