vb2010 and access database error in program files

[jkoroso]

Hi!

I finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path “program files” and this path is only read And my application crahed. I know how to installer put database in other path but I don’t know how to tell my application to find this database.

thanks

 

[Keyth]

Install to the new path

At runtime change your connectionstring property to point to the new path

Example:

    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Me.OleDbConnection1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Database.accdb"
    End Sub

 

[jkoroso]

Thaks Keyth!!


it´s great solution, i added my conection string drag and drop, not by code. i will change the paht