hi, i create a program with adodc and data, i created an exe file and installer of if, then i install it to other pc, but an error msg appear, there is a problem on my path of adodc to the database, but i was installed it to exact location in my pc. How can i make that the database and adodc1 are still connected even their directory change.? THANKS !

Hi,

Place the Database in the same folder as the project/application... and wrire this code in form_load..:

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path _
    & "\MyDB.mdb ;Persist Security Info=False"
Adodc1.Refresh

change database name accordingly..
bind all the controls, in runtime.. not design time...

Regards
Veena

Hello You Can use Package and Deployment Wizard to make an Setup.exe for your Project in Vb 6.0 then Make it Sure Your Database Added to Installation.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.