Auto find data: source=Me.exe & "???.mdb"

[AccessDevJunior]

hya,
i have designed an application in vb6 i wish to distribute but if i compile it to an exe the route to my data source will be incorrect on other user's machines, currently the path is:

Source=F:\BCT\BCT_be.mdb;

i was wondering if it is possible to change it to this:
source = me.currentlocation(location of my.exe) & "BCT_be.mdb

if anyone could help me with this it would be a great help?

as well what is the 'package and development wizard'?

 

[jebenson]

Use App.Path:

source = App.Path & "\BCT_be.mdb"

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[jebenson]

Use App.Path:

source = App.Path & "\BCT_be.mdb"

As to the Package and Deployment Wizard (PDW) - you can do a search of theis forum and find a lot of info about it. However, a lot of people (myself included) have major poblems with it. Have a look at INNO Setup (just Google for it) - its fre and works much better.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson