Bruce H. Johnson
bhjohnson at verizon.net
Tue Jun 5 13:28:04 CDT 2007
Thanks. Martin Reid says Sharepoint stores the actual docs in the database. Another small CMS does the same. Sounds, uh, frightening to me. I'll go with the folders on the server. Bruce H. Johnson Sylmar, CA -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, June 05, 2007 11:18 AM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] Best Practices for Document Content Management? 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 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.9/834 - Release Date: 6/5/2007 2:38 PM 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