If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Data Connection Problem

When I developed a front end to a database, the database was in its
own directory and the project in another. When I attempted to
distribute the package (the front end and the database), of course the
location of the database on the installed computer wasn't the same as
on my machine, it was in the same directory as the program. The
installed program couldn't find the database. It was looking where
the database had been on my computer.

When I changed the data connection to coincide with the application
directory, I continued to get path errors, and couldn't build the
project. Something was still looking for the database in the old
directory.

Re: Data Connection Problem

"Scott" <bangorme@hotmail.com> wrote:
>When I developed a front end to a database, the database was in its
>own directory and the project in another. When I attempted to
>distribute the package (the front end and the database), of course the
>location of the database on the installed computer wasn't the same as
>on my machine, it was in the same directory as the program. The
>installed program couldn't find the database. It was looking where
>the database had been on my computer.
>
>When I changed the data connection to coincide with the application
>directory, I continued to get path errors, and couldn't build the
>project. Something was still looking for the database in the old
>directory.
>
>Anyone got an idea?
>

I had the same problem. When you package the install you must make sure to
include the database in the files to install. This does not happen by default.
This will install your database into the root directory of the program. Then
your ..\database.mdb path should work.
>Thanks
>
>Scott
>

Re: Data Connection Problem

When Creating Distribution files ,(VB6.0)
Choose $App Path
This will be the path wherever the user chooses to install the programs.
Good Luck!

"Scott" <bangorme@hotmail.com> wrote:
>When I developed a front end to a database, the database was in its
>own directory and the project in another. When I attempted to
>distribute the package (the front end and the database), of course the
>location of the database on the installed computer wasn't the same as
>on my machine, it was in the same directory as the program. The
>installed program couldn't find the database. It was looking where
>the database had been on my computer.
>
>When I changed the data connection to coincide with the application
>directory, I continued to get path errors, and couldn't build the
>project. Something was still looking for the database in the old
>directory.
>
>Anyone got an idea?
>
>Thanks
>
>Scott
>