try to link the table from sqllite but an error appears near linked
Code:
Private Sub Command0_Click()
Dim connection As New ADODB.connection
Dim rst As New ADODB.Recordset
' Set the connection string
connection.ConnectionString = "DRIVER={SQLite3 ODBC Driver};DATABASE=e:\mydb.db"
' Open the connection
connection.Open
' Create a linked table in the Access database
rst.Open "CREATE LINKED TABLE Client TO [ODBC;DRIVER={SQLite3 ODBC Driver};DATABASE=C:\mydb.db].[Client]", connection
' Close the connection
connection.Close
End Sub