Ms Access execute query file select

[Ardi_Hermanto]

I want to input this file path

To this section database file name

If I run the massage said this

Can anyone help me solve this

[Slavia_Monteiro (Slavia)]

Hello Ardi,

First create the connection string . And once you have created it then replace it with the File value.

Something like this :
“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”+File.toString

Hope it helps you!!

[Ardi_Hermanto]

Like this one right ?

If yes i’ve try and that message still come

[Slavia_Monteiro (Slavia)]

Can you share your connection string ?

[Ardi_Hermanto]

like this

[Slavia_Monteiro (Slavia)]

Since you have used directory , it will give you a String. So refer to above screen shot and try once.

[Ardi_Hermanto]

thanks for your help