>>>>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 ...
< snip >
>
>Then try :
>"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\myPath\mydatabase.mdb;SystemDB=C:\myPath\mydatabase.mdw;"
>Cetin
Got the connection and returning data but the 'Select Data Source' dialog keeps popping up when I run my test program.

lcConnection = "{Driver=Microsoft Access Driver (*.mdb)};Dbq=\\dbsvr1\uadata\classic01\ClassicDesignServices.mdb;";
"SystemDB=\\dbsvr1\uadata\secure\UA65FS.mdw;uid=administrator;"
STORE SQLSTRINGCONNECT(lcConnection) TO lnAccess
? lnAccess
IF lnAccess < 0
	AERROR(aErrMsg)
	MESSAGEBOX(aErrMsg(2) + CHR(13) + aErrMsg(4) + CHR(13) + aErrMsg(3), 64, "Error")
ENDIF
IF SQLEXEC(lnAccess, "SELECT [tblCustomers].[CustomerID] FROM [tblCustomers]";"
        WHERE [tblCustomers].[Cust#] = 'CAR100'") < 0
	AERROR(aErrMsg)
	MESSAGEBOX(aErrMsg(2) + CHR(13) + aErrMsg(4) + CHR(13) + aErrMsg(3), 64, "Error")

ENDIF	
BROWSE
USE
? SQLDISCONNECT(0)

***I saw the issue! Misplaced bracket. Confirms to me that 90% or more programming errors are punctuation. Thanks, Cetin

Matthew