[dba-Tech] Best Practices for Document Content Management?

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
 




More information about the dba-Tech mailing list