-
Mar 29th, 2006, 12:56 PM
#1
Thread Starter
Lively Member
Change the app.path? VB6 & Access
I have used the Package & Deployment Wizard to put my Visual Basic Program on CD, I then copied over my database 'calculations.mdb' onto the cd also so that the VB program can access the database when installed on another PC. However, the program still searches the same path as it does on my computer when trying to open the database whereas i would obviously like it to search for it wherever the user installs it. Is it possible to hardset this in my VB code? This is what it is set to at the moment:
conconnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\" & "calculations.mdb;Mode=Read|Write"
Does anyone know how I can adapt it? If not, is it possible to set it to search on the CD in the disk drive?(although this would be awkward as the user would have to keep the cd in there but better than nothing!)
Thanks a lot!
Amy
-
Mar 29th, 2006, 01:01 PM
#2
Re: Change the app.path? VB6 & Access
When you create the Package and Delopment setup include the database in the setup files. This will place the DB into the same forlder as the app as it gets installed. Then you don't have to change the VB code it will still reside in App.Path
Sometimes the Programmer
Sometimes the DBA
Mazz1
-
Mar 29th, 2006, 01:21 PM
#3
Thread Starter
Lively Member
Re: Change the app.path? VB6 & Access
Sorry im not sure where you mean exactly. do i need to do that during the PDWizard or after? Once the package is created there is a folder called 'Support' but i tried putting it in there and didnt work. I also need to include the MS text-to-speech engine so that it installs if people dont have it. Would i just include this the same way as i will with the database?
Thanks!
-
Mar 29th, 2006, 01:32 PM
#4
Re: Change the app.path? VB6 & Access
The Package and Deployment Wizard will give you the option of adding files to the installation package (beside the OCX's and DLL's that it thinks belong). If you add the database file at this point the installation will include the file when the app is installed on the machine.
Sometimes the Programmer
Sometimes the DBA
Mazz1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|