Problem with accdb database

[christopher]

Hi,

My problem : VB.NET Application with database works fine local
once i publish the application, install it, i get database not found exception.
ive checked every road i can think off, ive included screenshots.
1 of the error
1 of the publish folder (wich shows my database.deploy)
1 of the properties of the database object in solution explorer->properties
1 of the publish section-> application files

I really hope someone can help me, this is killing me
thanks.

 

[christopher]

found path where my db is at

This is a path i found while browsing my folders
C:\Users\Christophe\AppData\Local\Apps\2.0\399QH983.H5T\8XPCH01G.ZXE\ggre..tion_a567c35f074961ae_0001.0000_67bfc36404b5942e\Database\
found database here

This is the path the published application looks for it :
C:\Users\Christophe\AppData\Local\Apps\2.0\Data\V9G55DLD.DA1\KHET7BNQ.NZ6\ggre..tion_a567c35f074961ae_0001.0000_67bfc36404b5942e\Data\
its not there obviously.

Error in the publishing of vs2010?

 

[JohnH]

Publish Status for db should be 'Data File'. In connection string use |DataDirectory| as relative path.

 

[christopher]

JohnH thanks!
it works great now.
you are a savior!
you are a god!
i love you!... lol
=-)
no but seriously thx.