changing system path from vba

  • Thread starter Thread starter Silvester
  • Start date Start date
S

Silvester

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.
 
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.
 
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
 
Back
Top