[AccessD] FW: [U] Soldier in Iraq needs Access Help

I would probably do this with SQL Server 2005 Express Edition
with Advanced Services.SQL Server 2005 Express Edition with
Advanced Services is perfect for use as a backend to a small, multiuser
application that requires more advanced features such as Web reporting 
or Full-text Search.
You could do this with the full version of SQL 2000 but now is available 
in Express.

SQL Server 2000 provides a rich text-data retrieval system and
an enhanced full-text search service that enables you to perform a 
linguistic
search of character data in tables enabled for full-text search.
A linguistic search operates on words and phrases.
The linguistic search is not supported for Arabic, but other parts of 
full-text search are.

Creating Full-Text Index
To accomplish a full-text search, you must create a full-text index on 
the specific column
you wish to search. To index a column in a table you are viewing, use 
the Full-Text Indexing Wizard.
In the Select Table Columns page, find the column you wish to index and,
in the Language for Word Breaker list, select Neutral.
Choosing this option enables your index to work with Arabic even though 
that language
is not included in the list of supported languages.
In general, use this option when a column contains data in multiple 
languages or in an unsupported language

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_arabicsupport.asp


You could do this with Google Desktop Search Engine via VBA API calls to 
return xml files
of retrieved data ranked by date or relevance. Caveats Security, Need 
addon's to
look deep into text and pdf files beyond 4000 characters.

Vista is supposed to have an inbuilt text search engine.




Beach Access Software wrote:

>Anyone want to tackle this one?  Sounds like an interesting project.
>
> 
>
>Rocky
>
> 
>
> 
>
>  _____  
>
>From: Access Users Group of San Diego [mailto:admin at augsd.org] 
>Sent: Friday, November 17, 2006 8:59 AM
>To: Wayne Warren-Angelucci; Rocky Smolin; Mark J. Krisburg; Joe Anderson;
>Dixon Foss; Barry Hynum (E-mail); Mike Dwyer; Ed Lance; Doug Murphy; Dixon
>Foss; Jackie Murphy (E-mail)
>Subject: FW: [U] Soldier in Iraq needs Access Help
>
> 
>
> 
>
>-----Original Message-----
>From: Newsom Lester SFC MNFI STARTEFF
>[mailto:lester.newsom at iraq.centcom.mil]
>Sent: Wednesday, November 01, 2006 9:12 AM
>To: admin at augsd.org
>Subject: [U] Soldier in Iraq needs Access Help
>
>Classification: UNCLASSIFIED 
>
>Greetings from Baghdad.
>
> 
>
>I am not one to ask for help until I have absolutely driven myself to the
>edge. It is my hope that you or one of your experts can shed some light on
>what I am trying to get Access to do.
>
> 
>
>There are actually two things, but first an explanation of what the database
>does. A team of translators interpret local Iraqi newscasts which are
>transcribed and input into the database. These transcriptions are referred
>back to on a regular basis via requests to my office by the higher-ups. A
>typical request would be along the lines of "Give me the instances over the
>past two weeks Prime Minister Maliki has said he likes the U.S." or, "Give
>me every article referring to IED's exploding in the past month"
>
> 
>
>A simple query of course, returns the date range and all articles whereas
>the word "Maliki" appears. I am helped by the fact that Maliki does not
>appear in the dictionary so I can scan through the articles, deleting those
>that are not relevant. I cannot however discern when IED is actually part of
>another word. 
>
> 
>
>What I would like to accomplish, is highlighting my text query, much like
>Google does in its cached pages. So, those words that I search for are
>highlighted, giving me a visual reference. 
>
> 
>
>I have tried constructing a macro to do the action and have also searched
>high and low in the Help files and the Internet.. Perhaps this makes perfect
>sense to you and you can point me in the right direction.
>
> 
>
>Thank you in advance for your time.
>
> 
>
>SFC Lester Newsom
>
>Baghdad, Iraq
>
> 
>
> 
>
>Classification: UNCLASSIFIED
>If this e-mail is marked FOR OFFICIAL USE ONLY it may be exempt from
>mandatory disclosure under FOIA. DoD 5400.7R, "DoD Freedom of Information
>Act Program", DoD Directive 5230.9, "Clearance of DoD Information for Public
>Release", and DoD Instruction 5230.29, "Security and Policy Review of DoD
>Information for Public Release" apply.
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.430 / Virus Database: 268.14.6/536 - Release Date: 11/16/2006
>3:51 PM
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada