Is this possible with MS Access ?

[sansangtracao]

I'm working for an office with a lot of data to be stored. The problem is the whole data is beiing stored in the form of TEXT which is very difficult to review and to track, therefore I intend to put the texts into several categories and using MS Access to manage. However it is unescapable that a large number of text (sometimes the whole contract text with more than 10 pages)) will be put into the database. My questions are:
1- IS IT POSSIBLE TO DO WITH MS ACCESS?
2- IF 'NO' THEN WHAT KIND OF SOFTWARE IS APPROPRIATE?
3- THERE IS A PROGRAM CALLED 'INFOPATH' WITH MS OFFICE 2003, QUESTION: THHIS PROGRAM HAS ANYTHING TO DO WITH ACCESS?
Any reply is appreciated.

 

[easyit]

This should very well be possible with access. You can store millions line of text, the limit is 2Gbyte for the whole DB. Check the import function of access.

 

[ZmrAbdulla]

I don't think Access can handle this. You need to have a software like NotesKeeper(

http://www.tolon.co.uk/notekeeper/)

which allow you to store text with tree based indexing.

There are many paid softwares like
TreeNotes(

http://www.coolutils.com/TreeNotes)

TreePad(

http://www.treepad.com/)

etc..
BTW..
here is the MS infopath home page

http://office.microsoft.com/en-us/FX010857921033.aspx

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[ZmrAbdulla]

I have posted without refreshing the page.. I didn't see easyit's post.

What I mean not possible due the formatting of the text as you stated as the text as contracts. Contracts can have bold/italic/color text that you can't use in Access.

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[sansangtracao]

Thanks Zameer,
It's still not answered my question. The question is that with quite a large ammount of text (not the format of the texts), how large the Accsess can handle? in one field, i.e "memo" field???

 

[easyit]

The memo field can contain max 64kb. You could have check Google....

But I would assume that your better of analyzing your text files and creating several fields instead of putting it all in one field.

Maybe you should be more specific on what you want, in order to get better help.

EasyIT

 

[MichaelRed]

An alternative might be to use Ms. A. as a "Library" database, store / save the documents as whatever type they are natively, let Ms. A. just keep control and track of them. There are examples of this approach in many places.



MichaelRed

 

[sansangtracao]

Thanks,
You guys are wonderful! Now I have some idea how to approach this problem !!! Thanks