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

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




More information about the AccessD mailing list