From: PAKSystems on 19 May 2010 09:23 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 19 May 2010 10:04 "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 20 May 2010 09:08 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?
|
Pages: 1 Prev: BUY FAKE PASSPORTS OF NETHERLANDS,FAKE DUTCH PASSPORTS FOR SALE! F Next: VB6 syntax question |