Connection String problem

[Phobbos]

I thought that when I used this code ...

dePenlogs.Connections("cnlogs").ConnectionString = App.Path + "\" + ("Temp.mdb")


When the app would be installed on the users machine it would find the database in the apps path but it does not. It tries to find the the database in the same directory as on my machine where the app was written WHY????

All I am trying to do is have a connection to the database without going through ODBC ( the only way I have ever done it). How do I do this (I am sure very simple) thing.???

PS. May the US find the #@S H%L#S Responible for the WTC bombing and blow them away aswell!!!!!!!!!

[Beacon]

try:

dePenlogs.Connections("cnlogs").ConnectionString = App.Path & "\" & "Temp.mdb"

else

What is cnlogs?

[Phobbos]

No it works fine on my PC. Ok I am writting my project in this directory. C:\Projects\MyProject

Now when I install the app on another pc and try to run it. It gives me an error somthing like:

Cannot find database in C:\Projects\MyProject

Now I thought that by using the App.path statement, the project would look for the database in the app directory, which would be
C:\ProgramFiles\MyProject

[Beacon]

yeah i agree with gab!

Coz app.path should do it that way!

or perhaps:

dePenlogs.Connections "cnlogs").ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\pathhere.mdb"

[Phobbos]

I think you may be right on what you say, I do have another ActiveX ado control on one of my forms, with I set the Connection String to the DataEnviroment connection through code, but i did see that it was hardcoded in the properties on that control, I will let you know when I P&D it again

Thanks