<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I am moving various access databases from a root directory to another directory. <br />
<br />
Before moving these databases, how to I list all the directory paths within the switchboard( queries) so that once I move my some databases to different folders, I can then edit my queries to pull the databases from the new location.<br />
<br />
Is there a systems objects command that I can use for this task?
</div>
</div>


Hi all,

I am moving various access databases from a root directory to another directory. 

Before moving these databases, how to I list all the directory paths within the switchboard( queries) so that once I move my some databases to different folders, I can then edit my queries to pull the databases from the new location.

Is there a systems objects command that I can use for this task?

List any directory paths in queries within Access 2010 all at once

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.