PDA

Click to See Complete Forum and Search --> : mdb problem with Package & Deployment Wizard


vbmmm6
Mar 10th, 2007, 07:45 PM
I have a project the uses an activex designer in a directory on drive E:

I use MSHflexgrid to create a report.

I used the Package & Deployment Wizard to create the package.

The problem I have is that after installing the package on another
PC (on the C: drive), when I try to open the form with MSHflexgrid, I get
the MS Jet ole DB initialization information box and the data source points
to the data base directory of the E: drive.

How do I tell the Package & Deployment Wizard to look for
the data base in the installation directory and not in the design directory ?

RhinoBull
Mar 10th, 2007, 09:14 PM
If e: was hardcoded in your program then there is nothing you can do except for making it dynamic - something like App.Path ...
Sounds like you're using Data control in your app.

RobDog888
Mar 10th, 2007, 10:20 PM
I agree that it sounds like you have hardcoded the path in your connectionstring. ie: used the ado connection wizard instead of manually coding in a dynamic variable like App.Path.

You need to change your code and recompile. Then repackage and that should take care of it.

vbmmm6
Mar 10th, 2007, 11:02 PM
I found the problem, the data link properties of the dsr file was pointing to the E: drive. I just put in the file name and that solved the problem.
Thanks anyway.

randem
Mar 11th, 2007, 03:45 AM
Solved it for now... Wait until someone changes the installation path...:eek2: