Re: Search for file that has been moved or link file to path?
- From: "paii, Ron" <paii@xxxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 12:38:03 -0500
"Bigrabid" <jwbackes@xxxxxxxxx> wrote in message
news:1177691882.429470.49050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Howdy,
I have an access database that I use to keep track of projects that my
group is working on. There are a number of files associated with any
one project, so I have [ProjectDescriptions] as a parent to
[ProjectFiles], which holds file paths for all of the most important
files (for easy access and tracking) and a short description of what
each file is. Now, sometimes a file (or a whole directory) will be
moved from outside the confines of the database, or the project folder
will be moved to a backup as the projects are completed, or something
else that makes the path in [projectfiles] not match up with the path
of the file any more.
So, is there a way to either:
Link the file to the database, so that if it moves it will update the
path accordingly;
or
execute a "find file" function that will search through folders and
subfolders looking for the file name (for instance, the saved path is
"C:\deals\JSIncomeStatement.xls" and then it is moved to "C:\deals\JS
\JSIncomeStatement.xls", is there a way to search through C:\deals\
and find all of the files with the name JSIncomeStatement.xls, and
list them, and allow me to choose the one that I want?
Or any other possible workarounds?
Thanks,
Bigrabid
I like a good "find file" function, it's not to slow as long as the search
area can be kept small.
.
- References:
- Search for file that has been moved or link file to path?
- From: Bigrabid
- Search for file that has been moved or link file to path?
- Prev by Date: Re: Continuous Form-Staying on current record
- Next by Date: Access Crashes When Rt Click Build in Query Design View
- Previous by thread: Search for file that has been moved or link file to path?
- Next by thread: Access Crashes When Rt Click Build in Query Design View
- Index(es):
Relevant Pages
|
|
