>Hi all,
>
>I'm trying to set up a pipe between an Access 2002 database and a FoxPro 6 free table. I'm connecting but I'm getting a syntax error that is driving me crazy.
>
SQLEXEC(lnAccess, "SELECT tblCustomers.CustomerID FROM tblCustomers WHERE tblCustomers.Cust# = 'CAR100'")
>
>AERROR() gives me the following...
>
>1256
>Connectivity error: Syntax error in date in query expression "tblCustomers.Cust# = 'CAR100'"
>
>The Cust# field in the Access table is a text field. CustomerID is a numeric(auto increment) field.
>
>I bracketed the table field names to match Access syntax and got the following error...
>
>1256
>Connectivity error: Record(s) could not be read; no read permission on tblCustomers.
>
>I am connecting as Administrator with full permissions on all tables. Any thoughts on what could be causing this?
>
>TIA
"SELECT [tblCustomers].[CustomerID] FROM [tblCustomers] WHERE [tblCustomers].[Cust#] = 'CAR100'"
works well for me.
Cetin