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