Hi,

Is there any way on mdb startup to make sure that our mdb directory is
included in the system path,

and if not to add it to the system path.

If so, please can you let me know the vba coding to achieve this.

Thanks in advance

You shouldn't need to. What are you trying to accomplish?

--
Wayne Morgan
MS Access MVP


"Silvester" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Is there any way on mdb startup to make sure that our mdb directory is
> included in the system path,
>
> and if not to add it to the system path.
>
> If so, please can you let me know the vba coding to achieve this.
>
> Thanks in advance
>
>

When I distribute a packaged app, sometimes it cannot find specified files
unless the app directory is added to system path.

I have found a way to modify path on setup using my installer, so vba is not
required.

"Wayne Morgan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You shouldn't need to. What are you trying to accomplish?
>
> --
> Wayne Morgan
> MS Access MVP
>
>
> "Silvester" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > Is there any way on mdb startup to make sure that our mdb directory is
> > included in the system path,
> >
> > and if not to add it to the system path.
> >
> > If so, please can you let me know the vba coding to achieve this.
> >
> > Thanks in advance
> >
> >
>
>

I hate install programs that think they should change the configuration of
my computer for their app to work. You can get the path to where the mdb
file is installed and call these other files using the full path. To get the
path to the mdb file in VBA:

CurrentProject.Path

will return the path to the mdb file.

You may also be able to accomplish what you want by setting the working
directory in the shortcut that opens your app.

--
Wayne Morgan
Microsoft Access MVP


"Silvester" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I distribute a packaged app, sometimes it cannot find specified files
> unless the app directory is added to system path.
>
> I have found a way to modify path on setup using my installer, so vba is
not
> required.
>
> "Wayne Morgan" <(E-Mail Removed)> wrote in
message
> news:(E-Mail Removed)...
> > You shouldn't need to. What are you trying to accomplish?
> >
> > --
> > Wayne Morgan
> > MS Access MVP
> >
> >
> > "Silvester" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hi,
> > >
> > > Is there any way on mdb startup to make sure that our mdb directory is
> > > included in the system path,
> > >
> > > and if not to add it to the system path.
> > >
> > > If so, please can you let me know the vba coding to achieve this.
> > >
> > > Thanks in advance
> > >
> > >
> >
> >
>
>

You are missing Wayne's point. A normal application >should not< be changing
the system path, if there is any other way to do what has to be done - and
there usually >is< some other way.

TC


"Silvester" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When I distribute a packaged app, sometimes it cannot find specified files
> unless the app directory is added to system path.
>
> I have found a way to modify path on setup using my installer, so vba is
not
> required.
>
> "Wayne Morgan" <(E-Mail Removed)> wrote in
message
> news:(E-Mail Removed)...
> > You shouldn't need to. What are you trying to accomplish?
> >
> > --
> > Wayne Morgan
> > MS Access MVP
> >
> >
> > "Silvester" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hi,
> > >
> > > Is there any way on mdb startup to make sure that our mdb directory is
> > > included in the system path,
> > >
> > > and if not to add it to the system path.
> > >
> > > If so, please can you let me know the vba coding to achieve this.
> > >
> > > Thanks in advance
> > >
> > >
> >
> >
>
>