VB executable can't find the database

[Darkprince]

Hi...

I am facing a strange problem. I have completed my project , in VB 6, which has forms talking to MS Access databases. It all works fine in the VB environment.

BUT, when I try to make the project as an .exe file (by clicking on 'Make EXE'), the resulting .exe file doesn't seem to be able to communicate to the connected database, although the database still resides in the same directory.
It says something like, "VB can't access the Jet-database...tec"...or something.

This project of mine is due in very soon, and any help in this would be very much appriciated.

Thanks

Sivas

[Edneeis]

Did you use relative paths in the app?
When you run a VB program from VB the directory is usually VB98 instead of the actual App.path unless you used app.path. Post some code and explain what error exactly you are getting.

[sky]

I had a similar problem before and used the package and deployment wizard to package the program and include all the files I needed to run the program outside of the vb environment. Once I exe the setup it provided, it worked.
There is a possibility that your program needs a certain file that the path is not laid down in code, but when packaged, is set in the system to allow it to be found?
It is worth a try.