searching memo fields

  • Thread starter Thread starter Arijit Upadhyay
  • Start date Start date
A

Arijit Upadhyay

My Access 2002 table has just two fields rowid & pages. The pages field
contain a large amount of data about 40 kb in a memo field. I am trying to
do a search on the memo field by criteria but it returns nothing.

PARAMETERS searchText Text;
SELECT Table1.csid, Table1.pages
FROM Table1
WHERE (((Table1.pages) Like [searchText]));

How to get a good result

Regards
Arijit
 
My Access 2002 table has just two fields rowid & pages. The pages field
contain a large amount of data about 40 kb in a memo field. I am trying to
do a search on the memo field by criteria but it returns nothing.

PARAMETERS searchText Text;
SELECT Table1.csid, Table1.pages
FROM Table1
WHERE (((Table1.pages) Like [searchText]));

How to get a good result

Regards
Arijit
Click to expand...

You need to use a wild card:

WHERE (((Table1.pages) Like "*" & [searchText] & "*"));
 
Thanks it worked.

I would like to ask a feasibility and database strength question. This
would be a cd based application developed with Flash & Access DB to
catalogue over 600 PDF's containing 8000 pages. The application needs to do
a full text search. So I am trying to keep the text contents of the PDF in
the memo fields. Approximately each row would contain around 40 kb data (as
saved in notepad), so in total about 25 MB of data in memo fields. The
fields are just two filenumber and filecontent.

Can Access handle this?

Regards
Arijit
 
Back
Top