MS Access VBA – Path of the Current Database

If all you wish is to determine the path of the current database, simply use the following line of code:

Application.CurrentProject.Path

It will return a string value like: ‘D:\MS Access\References’

Pay particular attention to the fact that it does not include the closing slash in the string it returns. So if you are going to use it in your code, remember to concatenate it with a closing slash by simply doing somthing like:

Application.CurrentProject.Path & "\"

View ratings
Rate this article

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>