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

Brock, Christian T, PERSCOM Christian.Brock at hoffman.army.mil
Thu Sep 18 06:42:12 CDT 2003


It can matter depending on what you will do with it.  For example, the
activeX component for FTP in Access97 cannot handle spaces in path and file
names, so therefore you would need to the shortname.
 
Christian Brock

-----Original Message-----
From: Backroads Data [mailto:backroad at idir.net] 
Sent: Wednesday, 17 September 2003 16:15
To: AccessD
Subject: [AccessD] Short vs. Long File Names - Does it matter?


Hi -
 
When I use CurrentDB.Name in code, sometimes it returns using short names,
like this:
 
C:\DOCUME~1\JULIES~1\MYDOCU~1\DEVELO~1\SomeFile.mdb
 
and other times it uses long names, like this:
 
C:\DOCUMENTS AND SETTINGS\JULIE SCHWALM\MY
DOCUMENTS\DEVELOPMENT\SomeFile.mdb
 
Does anyone know why it would vary?  (Sometimes re-booting gets it to switch
back to long file names, but not always - and not today!)
 
I guess more important - does it matter?  In code I want to create a small
text file in the same directory where the app is stored.  Other code will go
look for this file and read its contents.
 
I'm using Access 97 and WinXP for development.  Finished product will be
Access97 runtime installed on anything from Win95 and up.  TIA for any
insights.
 
Best Regards,
 
Julie Schwalm
Backroads Data
www.backroadsdata.com <http://www.backroadsdata.com> 
785-594-6807

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030918/7c9b0ede/attachment-0001.html>


More information about the AccessD mailing list