Where's Waldo

[Karma31251]

I need to know how to add files to the Application Files List in publish section of a project in VB 2005 Express Edition, specifically a database file. The file is in the resource section but i need it to show up in the application files list. i dont need to add it to the resource file i need to add it to the Application file list so that i can deem it a data file and the program will place the file in the correct place to be accessed by the program otherwise when i install the program it looks for the database and cannot find it, then errors out and shuts down the program. Unless anyone knows a different way to tell the installer to copy that database file to the correct path?

[Christian Graus]

What installer are you using ? I can put any file I want, anywhere I want with every installer program I've ever used.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

[Karma31251]

windows installer 3.1 i guess, i mean i am using the options provided by the VB 2005 Express Edition should i be using the a third party installer -- modified at 15:21 Wednesday 10th January, 2007

[Dave Kreskowiak]

He's using ClickOnce Deployment. IMHO, a nasty little can of worms. :laugh:

Dave Kreskowiak Microsoft MVP - Visual Basic

[Dave Kreskowiak]

You're going to have to modify your code so you can find the database if you're going to deploy your app using ClickOnce (or Publish) deployment. This is because your database file (.MDB) is going to end up in a different folder than your app's .EXE. You'll have to modify the code so you can specify the FULLY QUALIFIED PATH to the .MDB file when you build your connection string to open the database. Details can be found here[^]. But, you just add your MDB file to your apps project to make it a part of the installation. ClickOnce will automatically put it in your apps Data folder when it's deployed on the client machines.

Dave Kreskowiak Microsoft MVP - Visual Basic

[Karma31251]

what do you mean by add because it is in the resource file and the program runs off the database in the IDE.

[Dave Kreskowiak]

Don't put it in the resource file. Use the .MDB file right off the drive. You can't use an Access database that's stored in resources anyway because you can't get write access to it. It MUST be accessed from a file on a Read/Write media.

Dave Kreskowiak Microsoft MVP - Visual Basic