Relative paths

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
 
M

Marshall Barton

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.
 
C

Charles

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