<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff size=2>I
use: Application.CurrentProject.Path </FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff size=2>which
gives the current path of the Access mdb.</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2>txtFile = Application.CurrentProject.Path & "\" &
Text.txt</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff size=2>might
work for you.</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff size=2>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.
</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff size=2>This
is for Access 2000, not sure if it will work A97.</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=625162220-17092003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Backroads Data
[mailto:backroad@idir.net]<BR><B>Sent:</B> Wednesday, September 17, 2003 3:15
PM<BR><B>To:</B> AccessD<BR><B>Subject:</B> [AccessD] Short vs. Long File
Names - Does it matter?<BR><BR></FONT></DIV>
<DIV>Hi -</DIV>
<DIV> </DIV>
<DIV>When I use CurrentDB.Name in code, sometimes it returns using short
names, like this:</DIV>
<DIV> </DIV>
<DIV>C:\DOCUME~1\JULIES~1\MYDOCU~1\DEVELO~1\SomeFile.mdb</DIV>
<DIV> </DIV>
<DIV>and other times it uses long names, like this:</DIV>
<DIV> </DIV>
<DIV>C:\DOCUMENTS AND SETTINGS\JULIE SCHWALM\MY
DOCUMENTS\DEVELOPMENT\SomeFile.mdb</DIV>
<DIV> </DIV>
<DIV>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!)</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Best Regards,</DIV>
<DIV> </DIV>
<DIV>Julie Schwalm<BR>Backroads Data<BR><A
href="http://www.backroadsdata.com">www.backroadsdata.com</A><BR>785-594-6807</DIV></BLOCKQUOTE></BODY></HTML>