MartyConnelly
martyconnelly at shaw.ca
Tue Jun 5 19:13:23 CDT 2007
There are length limits if you save directory and file structures to CD's The limits are defined by the Joliet CD standard. Dan Waters wrote: >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