runtime error -2147467259(80004005)

[kamskate]

i am using vb6 as front end and back end as ms access. I have created software on my standlone pc on d: drive . i am using ado connection for connecting to .mdb database. I made .exe of project and created a deployment package using setup factory version 5 software. When i installed this package on d:\ drive then it works fine. but if i installed it on any other drive then it gives me runtime error -2147467259(80004005) and msessage invalid database path. I am using App.path + "\filename.mdb" in the connectivity


i a new and unexperianced one please help me

[kamskate]

some please help me sort out this runtime error

[Optional]

Are any of the other drives you get the error on mapped network drives ?

In addition, when you get the error, have you verified "filename.mdb" exist at App.path + "\filename.mdb" ?

Worst case scenario add the following line to your code, recompile and validate the path your application is expecting your mdb file to be in:

Call MsgBox(App.Path & "\filename.mdb")

This way you know for sure what the path is and then can verify the file exists at that location.

Edit
Thanks Akhilesh
I fixed it in my copy/paste as well as it is correct for string concatonation to use & instead of +.

[akhileshbc]

An additional note:

I think, for concatenation, & symbol is better then + symbol...