[AccessD] Short vs. Long File Names - Does it matter?

Bob Hall rjhjr at cox.net
Wed Sep 17 15:44:35 CDT 2003


On Wed, Sep 17, 2003 at 03:29:52PM -0500, Jim Hewson wrote:
> I use:  Application.CurrentProject.Path 
> which gives the current path of the Access mdb.
>  
> txtFile = Application.CurrentProject.Path & "\" & Text.txt
> might work for you.
>  
> I use this method for a database that is constantly moving to different
> machines, different users to access pictures.  I haven't had any problems
> yet.  
> This is for Access 2000, not sure if it will work A97.

IIRC, the CurrentProject object was introduced in Acc2k. I don't 
think it exists in Acc97. It would be nice to have a solution for 
non-truncated paths in Acc97. I've looked and never found one.

Bob Hall


More information about the AccessD mailing list