[RESOLVED] Database File Not Found After ClickOnce Installation

[gwboolean]

I am having what I believe to be an issue publishing a database application. At first, I thought it might be a connection issue, but after a lot of review, I believe that there is something that is not being set correctly prior to publishing the database application.

While running the application in Debug mode, there are no failures of any kind. All queries run successfully and as expected.

Of note. There was a message that popped up the first time I ran the application in debug mode. I was unable to document the message, but I answered no and the application continued. Likely that is very important, but I do not have the information.

I then ran the build process. It succeeded with no errors.

I then ran the publish process. It succeeded with no errors.

At the first request made to any query, from the menu, the message below was generated.



I checked and the directory exists. As the message indicated, there was no copy of MasterBase.accdb located in that directory. There was, however, other material, as listed below.



I believe that this directory, and it's contents are generated when running the Setup.exe file, but have been unable to verify that. I also believe that a copy of the database, MasterBase.accdb should be in this directory.

It appears to me that I have failed to define some setting in the project properties that points to the database. However, I have no idea what or where to do that. Of course, I could be completely off-base and the issue is something entirely different.

[jmcilhinney]

I have moved this thread to the Application Deployment forum because it is about deployment and nothing specific to do with VB.NET. I have also renamed the thread to provide more specific information about the issue.

[jmcilhinney]

Is your database file included in your project, i.e. listed in the Solution Explorer? If so, select it, open the Properties window and tell us what you see. You can provide a screenshot if you like but DO NOT post it using the Insert Image tool. Click the Go Advanced button and manage attachments from there. Assuming the file is included in the project, go to the Publish page of the project properties and see what files are included there. If the data file is not included, that would explain why it's not installed, so you would need to fix that. If it is included in the publish then there's a mystery to solve.

[gwboolean]

Is your database file included in your project, i.e. listed in the Solution Explorer?

No, it is not. The only place that I have the database is in the Server Explorer. I sometimes have a dataset in the Solution explorer. But I haven't gotten to the point of needing a dataset yet, with this application.

so you would need to fix that

Should I install a Dataset? The only Database that I have available to install is a Service-based database, which I know nothing about.

There is no database in the application files of the Publish properties page of project properties

[gwboolean]

so you would need to fix that.

Got it fixed. It's there now and the database shows up in the application files. Thanks!!!!