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

Unfortunately TRIM has a problem with the search engine which throws up
inconsistent results in large environments.  Probably has some kind of
buffering issues. 

There have been some disastrous attempts to link it with Windows and Outlook
in large government departments 

Because it is so confusing and non-intuitive, people try to avoid it and
wind up storing their documents in Windows.

I expect TRIM would be good if it's configured properly and people know how
to use it, but I have been in several government organisations that are
trying to make its use mandatory and they all have major problems with it.

  _____  

From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Jasmine Andrews
Sent: Tuesday, August 26, 2008 9:13 AM
To: austechwriter@xxxxxxxxxxxxx
Subject: 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 <http://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.writeideas.com.au/> 
http://www.alliance.org.au/freelancers/journalists/write_ideas/details/
mailto:writeideas@xxxxxxxxxxxxxx

21 Years of Write Ideas!

Other related posts: