update paths when files are moved

[Bigrabid]

I am using access to keep a database to track projects that my company
is working on. I have a number of tables, including
ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
paths of all of the important files for each project. ProjectFiles is
a child to ProjectDescriptions, holding the paths of a number of files
for each project.

Files often get moved around apart from the database - my question is,
is there a way to link the files to the [paths] field in ProjectFiles
so that if a file gets moved manually it automatically updates
the .mdb file? What other solutions would there be to this problem?

Thanks,
Bigrabid

 

[Bigrabid]

I am using access to keep a database to track projects that my company
is working on. I have a number of tables, including
ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
paths of all of the important files for each project. ProjectFiles is
a child to ProjectDescriptions, holding the paths of a number of files
for each project.

Files often get moved around apart from the database - my question is,
is there a way to link the files to the [paths] field in ProjectFiles
so that if a file gets moved manually it automatically updates
the .mdb file? What other solutions would there be to this problem?

Thanks,
Bigrabid

no reply yet...

 

[John W. Vinson]

I am using access to keep a database to track projects that my company
is working on. I have a number of tables, including
ProjectDescriptions and ProjectFiles - ProjectFiles keeps track of the
paths of all of the important files for each project. ProjectFiles is
a child to ProjectDescriptions, holding the paths of a number of files
for each project.

Files often get moved around apart from the database - my question is,
is there a way to link the files to the [paths] field in ProjectFiles
so that if a file gets moved manually it automatically updates
the .mdb file? What other solutions would there be to this problem?

Thanks,
Bigrabid

I'm not visualizing this, I guess. Do you want Windows Explorer, or DOS, or
any of the myriad tools someone could use to move files to open your database
and update the table? If so, then no, there's no way.

John W. Vinson [MVP]