Access suitable as a basic doc-management system?

[Andy]

I have been using PCs for many years but I am new to MS Access.

Is Access a godd choice if I want to have a "text database" of a few
hundred letters.

I would like to do searches of the text in the letters and maybe even do
searches similar to the simple search which Google allows for the Net.

I had thought about using a Desktop Search utility for my letters
database but it seems like overkill.

So should I use Access for this purpose or maybe something else is more
suitable?

 

[Albert D. Kallal]

Well, actually, ms-access is weak in text searching.

So, one of those "desktop" search engines is likely a better choice.

So should I use Access for this purpose or maybe something else is more
suitable?

If you wanted to track correspondence, and keep a update to list of
customers, and what you sent them, then ms-access becomes quite a good tool
(and, you would not store the list of documents in ms-access, but only a
list (links) to/of the documents sent.

So, for organising structured data, ms-access is ideal. For searching a
bunch of documents/text...no, it is the wrong tool....

 

[aaron.kempf]

yes.. Access can search through text quite well.

it really depends on how many text documents you want to search
through.

I would reccomend using Access Data Projects.. build a UI.

then you migrate it to Access 2007 / SQL 2005 with 'full text search'
and you can use the 'contains' keyword.

it's pretty damn powerful