Question Database Path Error

[jadallah]

Dears,

I have done a windows application VB.NET with access Database. while working on it, i had the database path

Private ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\LBCvehicles.mdb;Persist Security Info=True"

But since i wanted to deploy this project and install it on another pc i dint want the DB file to stay on C so i added a new folder to my project "DB" and added to it the access file.

Private ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= .\DB\LBCvehicles.mdb;Persist Security Info=True"

and i tried it before deployment everything worked fine.

I deployed the application and when running the setup file i got the following error :
"The folder path'.' contains an invalid character"

Please i need your help !

 

[Don Delegate]

Why don't you use the |DataDirectory| substitution string?
(If needed you can even set this value from AppDomain.SetData).