Please guys i need your help i developed software in vb.net that uses access 2003 as its back end database, but i always encountered problem after deployment as the programme cant communicate with database. What i want to know specifically is that how to deploy applications with access database in vb.net, and how to include .Net framework, to that when installating the application the installer can install .Net framework together with the application.


Thanks

Use innosetup for deploying your applications. Go through it and if you have problem then I will help you.

Info:
http://www.jrsoftware.org/isinfo.php

DownloadLink:
http://www.jrsoftware.org/isdl.php

FAQ:
http://www.jrsoftware.org/isfaq.php

best

T.Red Ur advice is quite wrong.i dont think that is the best practice because if you hard code the database part into your software the target computer(ie the computer you are installing the software into) might not store the file in the same location.

What i do most times is either i put the access database in the C drive (ie C:\access.mdb ) and code it that way or you use code that automaticall seach for your database file wherever it is. for example

Dim STrPath = System.IO.Directory.GetCurrentDirectory & "\access.mdb"
Hpe it helps.

I would suggest using Microsoft.Jet.OLEDB.4.0 and setting a path. This is the simplest. However, put the access database in the same path as your application start up path.

With

With my 5yrs experience working with VB.NET, i can tell you that boogie_1's advise is the best so far. You can either use the default application startup path or a designated folder to copy your database.
You can check if .NET framework is available by going to Projects-->Properties-->>Publish-->> Prerequisites, Then select what ever u need to be present before your program can be installed, Goodluck