Database Connection in vb

[barbs2]

I am using the following connection in VB to connect to an access db:

cn.Open ("Provider=Microsoft.jet.oledb.4.0;" & _
"Data Source=" & App.Path & "\db1.mdb&quot

However I am getting a runtime error saying that it cannot find the file but it also states the path to the file. Why can it know the path but not find the file?

 

[LazyMe]

That's because you supplied it that path. It states it can't find the path you supplied.
Greetings,
Rick

 

[Merlijn]

Put a MsgBox statement right above the cn.Open statement.
Like so:

MsgBox App.Path & "\db1.mdb"

See what it returns. It might be that the path is invalid and therefor generates the error.
I've been told that App.Path does not allways returns the correct pathname. Just debug it with a messagebox and you'll know more.