Dan Waters
dwaters at usinternet.com
Tue Jun 5 18:21:09 CDT 2007
In one of the systems I wrote we limited the length of the file name so that it would fit completely in one line at the top of the Cover Sheet report for that document. First you need to determine the font size and style, and report margins, then just experiment. It was sufficient - I think it was about 65 characters, not including the file extension. Dan -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Tuesday, June 05, 2007 5:13 PM To: Discussion of Hardware and Software issues Subject: Re: [dba-Tech] Best Practices for Document Content Management? I have one written in Access for a junior college. It handles offline storage, paper files retention dates, responsibilty, it was setup to create a windows directory structure based on the business taxonomy file series numbers and corresponding names This corresponds to a three level key in Access and 3 level windows directory. It also has to handle Freedom of Information and Data Privacy info. The first thing to do is setup a functioning files series taxonomy to store files. This should be setup with Records Management staff if you have any. I can't give you final product but can give you first trials just to show complexity involved. One problem I ran into was length of directory names and also special characters created from field names. Just remember Sharepoint Lists can accessed as Access tables from Access 2003 + It is as simple to use as a linked table manager. Bruce H. Johnson wrote: >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 > > > > -- Marty Connelly Victoria, B.C. Canada _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com