From: PAKSystems on
I have been asked to write a program that, in addition to keeping track of
club members, will allow the clubs secretary to take minutes at meetings and
will allow a full text search. I am using VB6 with Access as the back end. As
you know, memo fields are not searchable and text fields can only contain 255
characters.

My question is, what would your strategy be to allow easy entry and
retrieval of information contained in the minutes? This is pro bono work, so
simple is better.

Regards,

Drew
From: Clive Lumb on
"PAKSystems" <PAKSystems(a)discussions.microsoft.com> a écrit dans le message
de groupe de discussion :
68936B28-8295-42F8-9E75-7FACA168CF6E(a)microsoft.com...
> I have been asked to write a program that, in addition to keeping track of
> club members, will allow the clubs secretary to take minutes at meetings
> and
> will allow a full text search. I am using VB6 with Access as the back end.
> As
> you know, memo fields are not searchable and text fields can only contain
> 255
> characters.
>
> My question is, what would your strategy be to allow easy entry and
> retrieval of information contained in the minutes? This is pro bono work,
> so
> simple is better.
>
> Regards,
>
> Drew

It would probably be a lot simpler to have the meeting minutes done under
some word processing software (Word if they're rich, Open Office if they're
not) and then either have your software analyse the minute documents and
index all the words in an Access table, or use the word processing API or
OLE to do any searching for you.

From: David Kerber on
In article <68936B28-8295-42F8-9E75-7FACA168CF6E(a)microsoft.com>,
PAKSystems(a)discussions.microsoft.com says...
>
> I have been asked to write a program that, in addition to keeping track of
> club members, will allow the clubs secretary to take minutes at meetings and
> will allow a full text search. I am using VB6 with Access as the back end. As
> you know, memo fields are not searchable and text fields can only contain 255
> characters.
>
> My question is, what would your strategy be to allow easy entry and
> retrieval of information contained in the minutes? This is pro bono work, so
> simple is better.
>
> Regards,
>
> Drew

Use some other free database solution that DOES allow searching long
varchar fields. MySQL? PostGres? etc?