Unable to open database?

[jeffro]

I'm trying to install a vb6 program to a user machine. I have several crystal reports that are connected to the program and get the information from a access database. After I install the program and go to run it and try to pick a report, I get an error that says Unable to open database. Can someone help me out with this error? I have no idea why the database will not open up.

thanks jeffro

[iandarbyshire]

Does your installation program install MDAC? If not you should add it.

[jeffro]

I do have the MDAC_TYP.EXE in the install for the program. Any other ideas?

Thanks jeffro

[PJB]

Is the path to the database set properly, it's not trying to find it along the path it was on on your machine is it?
I'm assuming it works fine on the machine you designed it on

[jeffro]

I have the program, database, and all the reports and forms in the h:\, but then I moved them to the p:\. I also changed the paths the reports and the connectionstring to go to the p:\. And then I tested the program on the new drive and everything worked out just great. Put when I installed the program on a user machine the reports will not show up. I'm not calling them from the old h:\ drive.

thanks jeffro

[Clunietp]

what is the EXACT error message that you are receiving? What database are you using?

[jeffro]

The error message is Error '20533' Unable to open database. I'm using Access 97.

jeffro