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

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
 











































































































































































More information about the dba-Tech mailing list