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

Erwin Craps Erwin.Craps at ithelps.be
Thu Sep 18 08:28:09 CDT 2003


>From my experiance 16 bit app/dll do seem to return 8.3 formats, but I
would not 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Thursday, September 18, 2003 3:12 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Short vs. Long File Names - Does it matter?


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