title: Find the directory part (minus the filename) of a full path in access 97
body: <p>For various reasons, I'm stuck in Access 97 and need to get only the path part of a full pathname.</p>
  
  <p>For example, the name</p>
  
  <pre><code>c:\whatever dir\another dir\stuff.mdb
  </code></pre>
  
  <p>should become</p>
  
  <pre><code>c:\whatever dir\another dir\
  </code></pre>
  
  <p>This site has some suggestions on how to do it:
  <a href="http://www.ammara.com/access_image_faq/parse_path_filename.html" rel="noreferrer">http://www.ammara.com/access_image_faq/parse_path_filename.html</a></p>
  
  <p>But they seem rather hideous.  There must be a better way, right?</p>