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

>Martin Reid says Sharepoint stores the actual docs in the database.

Yes, but a SQL Server database, not an MDB BE. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----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 2:28 PM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Best Practices for Document Content Management?

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