• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

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

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?
0
lynmke
Asked:
lynmke
1 Solution
 
COACHMAN99Commented:
If they are back-ends bound to front-ends you will have to re-link them.
If the code is using hard-wired text (paths) then you will have to find and replace.
0
 
lynmkeAuthor Commented:
Sorry for my tardiness!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now