How can I link data in MS Access to data in a directory?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a lot of documentation that we want to keep track of in Access.
However everytime we update the documentation we don't want to have to update
the database bacause there is a constant update. Is there a way we can link
document location and revision date to a database so that it updates as the
documents get updated?
 
Hi Josh,

Access can't link to a file system as if it was an external data source.

It is possible to write code that uses a FileSystemObject or the old
Dir() and FileDateTime() functions to retrieve the names and timestamps
of files in a folder or tree as needed - or even to use them to populate
temporary tables. But this wouldn't create any real link between the
file and the database: that will have to wait for the next Windows file
system, due (I believe) sometime after the release of Windows Vista.

In the interim, it might be worth investigating Sharepoint: documents
stored in a Sharepoint library are a SQL Server database that Access can
query.
 
Back
Top