MartyConnelly
martyconnelly at shaw.ca
Wed Sep 17 16:23:59 CDT 2003
API: Get Short and Long file names http://www.mvps.org/access/api/api0020.htm Bob Hall wrote: >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 >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > >