This is one of the ways I connect to VFP free tables. It's important to realize that you are actually connecting to the directory where your free tables are resident.
'-- Create ODBC connection to VFP directory.
StrConn = "DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};UID=;PWD=;SourceDB=c:\altus_quote\data;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
set Conn = server.createobject("ADODB.Connection")
Conn.Open StrConn
' Create a command object.
set Cmd = Server.CreateObject("ADODB.Command")
'Create data-set for uploading
buildSQLInsert("company")
cmd.ActiveConnection = Conn
cmd.CommandText = (SQLInsertStr)
cmd.execute
C. W. Finch Consulting