I use this function for connection with the table
Public Function InitFoxConnection(ByVal lPath As String, ByRef lCon As ADODB.Connection, Optional lExclusive As Boolean = True, _
Optional lUser As String = "", Optional lPassword As String = "", _
Optional lSourceType...