Dan Waters
dwaters at usinternet.com
Tue Jun 5 13:17:53 CDT 2007
Bruce, I've done this for two customers. Do not store the documents in Access tables. You can move/copy/delete documents using FileSystemObjects code, and you can open a document using hyperlinks created in code immediately before the document needs to be opened. And you can set up a folder structure the way you want to store the documents. Doing this is a lot safer - if your database happens to get corrupted, you won't lose the documents. Best of Luck, Dan -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Bruce H. Johnson Sent: Tuesday, June 05, 2007 12:02 PM To: dba-Tech at databaseadvisors.com Subject: [dba-Tech] Best Practices for Document Content Management? I've been tasked to create a small document managment system with Access. Any pointers to best practices on storage (folder/directory sturcture, etc) and versioning? I spent an hour on MSDN tooking at the Sharepoint Portal server documents. In the best MS tradition, it said the documents were stored in the database but still kept talking about folders. Bruce H. Johnson Sylmar, CA No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.9/834 - Release Date: 6/5/2007 2:38 PM _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com