Database Error

Karma31251

ok so i am making a program with VB 2005 Express Edition and an Access database connected to it. when i run the program in the IDE it works fine but when i install it and run it, it talks about not being able to find the database. Now my question is... when you make a program with a database in the resource file, isn't the program supposed to copy to database to where ever it is supposed to read from and if it isnt then where\how to i get the program to copy and read the database upon installation. Also, i am keeping on the back burner the fact that when i install the program i want to be able to go into the database and change information and/or be able to print reports on the data. the error: upon startup the program cannot find the database and is looking in a folder that the program creates on its own(i didnt programmably make it) the folder: c:\Documemts and Settings\myUser\Local Settings\Apps\2.0\Data\993YD61J.131\C9JHJHC1.JGY \star..tion_8549497152147e43_0001.0000_603d66f8611c4d37\Data\Resources\ now why would it be looking there of all places and how can i correct this problem, this tis the knowledge i seek! lol thanks Joshua

Dave Kreskowiak

You have to include the .MDB file in the installation project and make sure that it get's placed in the folder that your app is expecting. There is nothing that does this automatically. It's just another file, like you app's .EXE, that you're responsible for in the install.

Dave Kreskowiak Microsoft MVP - Visual Basic

Karma31251

Ok so how would i add it i mean im using VB 2005 Express and i dont know if thats even an option, if it is i cant find it. Id ont think they give you a lot of options in the free version. anyone know a good How To on attach a data to an installation file?

Dave Kreskowiak

Well, I played with ClickOnce for a little bit. It doesn't look like you can add the extra file. I actually have no idea if you can or can't. I don't use ClickOnce for any of my deployments.

Dave Kreskowiak Microsoft MVP - Visual Basic