Relative paths

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I need to access a file on my C: drive but do not want to hard code the path. Does MS access 2003 allow for relative paths and if so how does one code it?



Thanks for your help





Charles
 
Charles said:
I need to access a file on my C: drive but do not want to hard code the path. Does MS access 2003 allow for relative paths and if so how does one code it?
Click to expand...


Well, not quite. You can fudge something together uaing a
shortcut's Start In setting, but it's a rather delicate way
to do things.

A much better way is to retrieve the path of the mdb file
using CurrentProject.Path or CurrentDb.Name. Then you can
use code to tack the specific part of the path on to the
mdb's path.
 
Thank Marsh,

That's exactly what I needed.

CL


Marshall Barton said:
Well, not quite. You can fudge something together uaing a
shortcut's Start In setting, but it's a rather delicate way
to do things.

A much better way is to retrieve the path of the mdb file
using CurrentProject.Path or CurrentDb.Name. Then you can
use code to tack the specific part of the path on to the
mdb's path.
Click to expand...
 
Back
Top