VB.net database connection

[jamesd0142]

Hi I'm using vb.net trying to use the 'app.path' to connect to my database.

Problem i'm getting is...

When i run the program, it tries to find my database in ...\bin\debug\* mdb
yet my .bmd file is in the project folder with all othe forms the program uses.

How can i change this path that my program uses to connect to my database?

Thanks

James

[debasisdas]

App.path means the path of the EXE file.

U need to change accordingly to your requirment.

[jamesd0142]

Hi thanks for the reply,

While I'm here could you help me im new to this and compltely confused.

I have a database called FAQs.mdb and my program connects to it using:
Dim Con As OleDb.OleDbConn ection
Con = New OleDb.OleDbConn ection("Provide r=Microsoft.Jet .OleDb.4.0;data source=" & Application.Sta rtupPath & "\FAQs.mdb" )

No my database is located in my projectfolder.. .\bin\debug

When i run the program in visual studio, it works perfectly.

Although...

When i publish my program the database doesnt seem to get copied with the rest of the program.

Why is this? OR Better still Where should i save the *.mdb file?

Thanks James