[sqlite] Connection string

On 8/12/2015 4:27 AM, faizel williams wrote: > I would like to create a link table in MS Access to a SQLite database. (Not > using ODBC driver) This can't possibly work. Access doesn't have any built-in knowledge of SQLite - by what magic do you expect it to acquire the ability to understand

[sqlite] Connection string

Hi, I would like to create a link table in MS Access to a SQLite database. (Not using ODBC driver) The following code works in MS Access, but link table are in another MS Acces database Private Sub CreateAccessLinkTable(ByVal stmtHandle As Long, newTableName As String) Dim td As DAO.TableDef

[sqlite] Connection String to SQLite3 Database using SQLiteODBC under VB.

Hello, Can anyone tell me how I can use an existing SQLite3 File-DSN under VB to connect to a SQLite3 database. Regards, Sami