Create Record when new file is created

  • Thread starter Thread starter m stroup
  • Start date Start date
M

m stroup

tblDocuments
Doc# (autonumber PK)
DocName
DocCreator
DocLocation
DocStatus

Currently, I am using this table to track document status.

Is there a way to automatically save the above information to the table
whenever I create/save a new file (be it access/word/etc)? I would also to
create a hyperlink field in the table and have that stored at the same time.

I have been doing some programming in access, but this would be done at a
higher level. Any help/references would be appreciated.

If it is not doable, that would be good info too :)
 
Is there a way to automatically save the above information to the table
whenever I create/save a new file (be it access/word/etc)? I would also to
create a hyperlink field in the table and have that stored at the same time.
Click to expand...

Only if you put code in ALL applications which will create files for you; this
code would need to open the database and add a record to the table. It's going
to be monstrous complicated.

You might want to consider instead having code in your database which can use
the Dir() function to poll through the folder/folders containing the files you
want to track. This program could update your table (e.g. do you want to
delete records from the table when a file is deleted or renamed?)

John W. Vinson [MVP]
 
Thanks, John. That sounds like a better approach. It would allow me to
locate files created by our team as well.
 
Back
Top