How to change DataBase localisation when publishing my app

Hi

First of all, it's my first post on this forum and I hope it won't be the last :).

I've been working on application using VB express 2010 that saves the information in an Access dbase.
Everything work fine except when I publish my application. The database is save in c:\User\AppData\Local....
Is there a way to change the localisation where my application try to find the dbase?

Thank you for your help and I hope this thread is in the right place:)

P.S Sorry if it's not very clear english is not my first language.

If you use the appropriate connection string, i.e. use "|DataDirectory|" for the folder path, then it will work without change, which is the whole point.

I'm allready using "|DataDirectory|" for the folder path in Myproject/settings/value. My application is using the database in DataDirectoy when debugging
but when I publish she's trying to find it in AppData folder.

Is this a Windows Forms app that you're publishing using ClickOnce? If so, is the database actually being included in the publish? You can find out from the Publish page of the project properties.

I'm using Clickonce for publishing my windows forms app. When I go in the publish section application files I see my database. After the publishing, I find my dbase.deploy in the applications file folder.

I don't really use ClickOnce myself but, if you're using |DataDirectory|, it should just work. Something is amiss but I'm not 100% sure what.

I don't get it too. For now I'm using the release folder to be able to run some tests on it.