VB.net - How to install it with other files

[emsik1001]

Hi

I would appreciate if someone could point me in the right direction.

I'm developing a small application which includes MS Access database in it.


When someone install it I need to know where the database was installed so I can update the connection string. Currently I use OnceClick VB 2008 feature and it doesn't alow me to specify the folder.

On Vista PC I have also some issues with the Access database if it is in C drive directly or Program Files folder it becames read-only and I cannot update/insert any records.


Many thanks in advance.
Emil

[lotus18]

@emsik1001
Hi

The simplest way on how to do it is using Application.StartupPath as your connection path for your access database.

Something like

Imports System.Data.OleDb
 
Public conn As System.Data.OleDb.OleDbConnection
 
Public Sub SetConnection()
conn=New System.Data.OleDb.OleDbConnection()
        Try
            conn.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=" & Application.StartupPath & "\Database\MyDatabase.mdb;" & _
            "Persist Security Info=False;Jet OLEDB:Database Password=password")
            conn.Open()
        Catch ex As Exception
            MessageBox.Show(ex.Message, "Connection Failed", MessageBoxButtons.OK, MessageBoxIcon.Error)
            conn.Close
conn.Dispose
        End Try

Rey Sean

[emsik1001]

Thanks that is what I was exactly looking for!!

[emsik1001]

Just an update

I have used this property to get the path but unfortunately my dataset has been using a different path.

After reading some forums I changed publish status to data file and used this property Application.UserAppDataPath to get the path and now my updates and dataset are synchronized.

Regards
Emil