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

Heenan, Lambert Lambert.Heenan at AIG.com
Thu Sep 18 08:12:21 CDT 2003


Certainly nothing to do with the disk format. You get short file names with
NTFS and FAT/FAT32 drives.

I use API calls to build the long or short names, whichever I need.

And yes, an MSDOS boot disk will have no access to an NTFS drive, though you
can get drivers that will permit this access.

> -----Original Message-----
> From:	Erwin Craps [SMTP:Erwin.Craps at ithelps.be]
> Sent:	Wednesday, September 17, 2003 4:59 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Short vs. Long File Names - Does it matter?
> 
> I wonder if this has anything to do with how your disk is formatted.
> 
> NTFS or FAT32 (or even less).
> 
> NTFS is way better. You can convert from FAT to NTFS using the convert
> command.
> This does mean that you can no longer access your disk when booting from
> a dos floppy disk.
> 
> -----Oorspronkelijk bericht-----
> Van: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] Namens Bob Hall
> Verzonden: woensdag 17 september 2003 22:45
> Aan: 'Access Developers discussion and problem solving'
> Onderwerp: Re: [AccessD] Short vs. Long File Names - Does it matter?
> 
> 
> 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
> _______________________________________________
> 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