Relative paths

[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

 

[Marshall Barton]

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?

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.

 

[Charles]

Thank Marsh,

That's exactly what I needed.

CL

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.