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

**experience** · Nov 27th, 2012, 05:19 PM

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)

**dday9** · Nov 27th, 2012, 05:21 PM

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.

**.paul.** · Nov 27th, 2012, 05:22 PM

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;"

**experience** · Nov 27th, 2012, 05:27 PM

Many thanks guys - Paul excellent work

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

Thread Tools

Display

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

Re: How do i add Application Data Folder path to my connection string?

Re: How do i add Application Data Folder path to my connection string?

Re: How do i add Application Data Folder path to my connection string?

Posting Permissions