link table from sqllite (1 Viewer)

[zezo2021]

try to link the table from sqllite but an error appears near linked

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

 

[theDBguy]

What was the error message?

 

[Ranman256]

did u try linking the table via the EXTERNAL DATA?
(not in code)

 

[zezo2021]

What was the error message?

 

[zezo2021]

did u try linking the table via the EXTERNAL DATA?
(not in code)

do you have any video?

I don't have resources link access with SQLite

 

[CJ_London]

CREATE LINKED TABLE

pretty sure that is not valid sql. You are also using ADO whilst access uses DAO.

do you have any video?

I don't have resources link access with SQLite

try experimenting

go to the External Data tab
click on odbc database
click on the link to datasource option
try navigating to the file data source, and select the DSN
or click on the machine datasource and choose your driver

in any event you will have to have installed your sqllite driver

 

[zezo2021]

pretty sure that is not valid sql. You are also using ADO whilst access uses DAO.


try experimenting

go to the External Data tab
click on odbc database
click on the link to datasource option
try navigating to the file data source, and select the DSN
or click on the machine datasource and choose your driver

in any event you will have to have installed your sqllite driver

 

[CJ_London]

I've no idea what you were doing when you generated that message, so cannot offer any insight.

After 300+ posts, you will know we need detail to provide assistance. if you can't be bothered to provide that, why do you think we should spend multiple posts guessing?

A simple google search found this link

Connecting Microsoft Access to SQLite via ODBC Driver

 

[zezo2021]

here is all steps in a video

 

[zezo2021]

I've no idea what you were doing when you generated that message, so cannot offer any insight.

After 300+ posts, you will know we need detail to provide assistance. if you can't be bothered to provide that, why do you think we should spend multiple posts guessing?

A simple google search found this link

Connecting Microsoft Access to SQLite via ODBC Driver

I saw this link before posting my post

not give me any solution

 

[CJ_London]

what don't you understand about it?

 

[CJ_London]

the quality of your video is too poor for me to see what you are doing.

Good luck with your app but I don't believe I can help with your quest

 

[AccessBlaster]

Not an expert, but around 0:00:12 seconds into your video you may need to "browse" to the backend location.