I am using the excel VBA to access the FoxPro free table thought out by the ODBC32. in that case the FoxPro free table is store in the server and share with my staff.
when i want to search the record in the free table. and run at
Set rstTemp = conMain.OpenRecordset(sSQL, dbOpenDynamic)
the VBA will be returne error message is that
"execution cancelled 3669"

my opendatabase and openconnection statement is that:

Set wrkMain = CreateWorkspace("hdfandtxf;", "Admin", "", dbUseODBC)
Set conMain = wrkMain.OpenDatabase("hdfandtxf", False, , "ODBC;DATABASE=hdfandtxf;UID=Admin;PWD=;DSN=hdfandtxf;[logintimeout=0];")
wrkMain.LoginTimeout = 0
' Set conMain = wrkMain.OpenConnection("hdfandtxf", dbDriverNoPrompt, true, "ODBC;DATABASE=hdfandtxf;UID=Admin;PWD=;DSN=hdfandtxf;[logintimeout=0];")

please help me ^_^