[RESOLVED] How do i add Application Data Folder path to my connection string?

My database is installed in the Application Data folder, how do i add that location to my database connection string?

Code:

---

Friend DBConnectstrings = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=????\database.mdb;Jet OLEDB:Database Password=123456789;"

---

Code:

---

Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData)

---

Take a look at the link in my signature: Let the user choose the connection string

Edit - Nvm, I misread your post look at .Paul. post below.

Code:

---

"Friend DBConnectstrings = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & io.path.combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "database.mdb") & ";Jet OLEDB:Database Password=123456789;"

---

Many thanks guys - Paul excellent work :)