Data List & ADO Data Control

[Chris cherryholmes]

In a small database project I've used Data bound List box bound to a ADO Data
Control. I've bound the ListField property to the 'ItemName' feild in the
database and then use it as a pick list to bookmark the selected possition
in the database. This all works great. The problem arises when I move the
app to a different location. It can't find the data base (path name wrong
error)even though I have written the connection string in the Form_load event
in the code module to point to the 'App.Path'. In debug mode the error arises
when ever it hits this line of code '.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & App.Path & "\Door Builder.mdb" '. The interesting thing is that
if I remove the Data List control and run the project again it makes the
connection fine finding the correct path. Is there something I'm missing
or is this a bug with VB. I've just installed SP 4 so I have the latest updates.
Help!!

Chris

[Paul Clapham]

Don't know if this applies in your case, but if your app's path is the root
directory of a drive, then App.Path returns e.g. "H:\" and then your Source
becomes "H:\\Door Builder.mdb", which is a Bad Thing.

<Chris cherryholmes> wrote in message news:39664cfb$1@news.devx.com...
>
> In a small database project I've used Data bound List box bound to a ADO
Data
> Control. I've bound the ListField property to the 'ItemName' feild in the
> database and then use it as a pick list to bookmark the selected
possition
> in the database. This all works great. The problem arises when I move the
> app to a different location. It can't find the data base (path name wrong
> error)even though I have written the connection string in the Form_load
event
> in the code module to point to the 'App.Path'. In debug mode the error
arises
> when ever it hits this line of code '.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=" & App.Path & "\Door Builder.mdb" '. The interesting thing is that
> if I remove the Data List control and run the project again it makes the
> connection fine finding the correct path. Is there something I'm missing
> or is this a bug with VB. I've just installed SP 4 so I have the latest
updates.
> Help!!
>
> Chris
>