Erwin Craps
Erwin.Craps at ithelps.be
Wed Sep 17 15:59:10 CDT 2003
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