atw: Fwd: Re: Document management systems using MS Access

Technically speaking, Access isn't a database but a database management
system (DBMS) with which you create a database. A database which is only as
good as its design/designer.

In terms of document management systems, nothing can beat a fully-featured
version of TRIM.

Jasmine Andrews

---------- Forwarded message ----------
From: Warren Lewington <wjlewington@xxxxxxxxxxx>
Date: 25 Aug 2008 22:12
Subject: atw: Re: Document management systems using MS Access
To: austechwriter@xxxxxxxxxxxxx



Like all databases, which is what a content management system ultimately is,
you need to have the whole application well designed. If you have time,
energy and resources, well, consider it. Access is an incredibly powerful
application, I can verify that a large number of city wide traffic systems
are happily crunching their lives away, with millions of things happening at
any time, on MS Access.



But the databases are well designed...



Regards;

Warren



*From:* austechwriter-bounce@xxxxxxxxxxxxx [mailto:
austechwriter-bounce@xxxxxxxxxxxxx] *On Behalf Of *Write Ideas
*Sent:* Monday, 25 August 2008 14:34
*To:* austechwriter@xxxxxxxxxxxxx
*Subject:* atw: Re: Document management systems using MS Access



Wrong tool for the job, David (P).

No check in / check out options, no version control management, limited (if
any) directory tree file handling and compression / encryption tools.

Such a system needs multiple levels of authentication.

If you are after such a tool from Microsoft, SourceSafe, which is also
widely used for software version control is the go.

Note: SourceSafe requires a very powerful and capable server with hardware
such as RAID arrays / hot swapping drives, streaming backup media and the
like. Otherwise, go the UNIX / Linux OS route, for which there is a wide
variety of highly capable and efficient file management software (even some
excellent shareware and freeware).

MS Access is not in that league and, IMHO, you will only suffer frustration,
fatigue and eventual brain meltdown if you venture down that path.

Hope that helps.

Cheers,

Micky G.
Write Ideas
www.writeideas.com.au

At 11:16 25/08/2008, you wrote:

Has anyone had any experience using MS Access as the platform for a document
management system?
-- 

David Petersen
Documentation Coordinator
Air Systems

Thales Australia


Michael Granat
*Write Ideas
*www.writeideas.com.au
http://www.alliance.org.au/freelancers/journalists/write_ideas/details/
mailto:writeideas@xxxxxxxxxxxxxx

<writeideas@xxxxxxxxxxxxxx>*21 Years of Write Ideas!*

Other related posts: