Include a database in deployment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've made a simple winform with access to an Access database. I work on my machine but when I install the MSI on another machine it looks for the database the wrong place, what would be the workaround

TI

Tommy
 
How are you specifying the connection string? The easiest method is to set
the connection string in the app.config and have all the data access code
look here for the connection string. You can then edit the config file to
point the spot where the MSI puts the access file.

mannik said:
Hi

I've made a simple winform with access to an Access database. I work on my
Click to expand...
machine but when I install the MSI on another machine it looks for the
database the wrong place, what would be the workaround
 
I made it with a DataForm wizard and it connects allright, my connection string looks as

OLE DB:Global Partial Bulk Ops=2,Jet OLEDB:Regesrty path D\Documents and settings......... and here is my database. I'v pasted the database to the Solution explore. I don't understand why I don't see the code to my database when I dobbelclick on my form. Where should I look for it

But I think I found a part of the problem, now I added following files (as I'm not sure which to add) to my installer:
Primary outpu
Content File
Source file
Localized file

Now I get another error when I test on pc no.2 it claims that there are a disk or network error. On pc no. 1 it works but this is the pc where I made the projec

I will be thankfull for all the help I can get

Tommy
 
Back
Top