Question

vb.net search through word documents

Asked by: wardo123

I need to search through thousands of Word docuemnts that list user info.  I wrote a VB program using Microsoft Visual Basic 2008 Express Edition, that will search for a user name in each of the documents.  This search is done by using StreamReader to load each file and then searching the file for a search string.  If this string is found I then open the workd docuemnt using Microsoft.Office.Interop.Word and pull out data to load into ta ListBox.
My problem is that some of the Documents actually have the user names in the header informaion, and it looks like StreamReader doesn't look at header information in Word becasue I never find a user if they are only listed in the header information.  Anyone know of a way around this?

Private Function CheckFiles(ByVal FileName As String, ByVal SearchWord As String) As Boolean
        'Searching for matching document and then pulling out the User name and Bith Date
        Dim IsWordFound As Boolean = False
        Dim strLine, strUserName, strBDate, orgStrLine As String
        Dim FileContents As String = String.Empty
        Dim FileStreamReader As StreamReader
        Dim MyCrLf As String
        Const MyCr As String = Microsoft.VisualBasic.ControlChars.Cr
        Const MyTab As String = Microsoft.VisualBasic.ControlChars.Tab
        MyCrLf = Chr(13) + Chr(10)
        'Dim fulWordFile As New Microsoft.Office.Interop.Word.Application
        'Dim Doc As Microsoft.Office.Interop.Word.Application
 
        Dim bFlag As Boolean = False
        Dim bFlagName As Boolean = False
        Dim bFlagBirth As Boolean = False
        Try
            FileStreamReader = New StreamReader(FileName)
            FileContents = FileStreamReader.ReadToEnd()
        Catch ex As Exception
            MsgBox(ex.ToString)
            IsWordFound = False
        Finally
            If Not (FileStreamReader Is Nothing) Then
                FileStreamReader.Close()
            End If
        End Try
        If FileContents.IndexOf(SearchWord) > 0 Then
            'IndexOf returns -1 of not found and 0 if the textVal is empty
            Dim lstItem As New ListViewItem
            Try
                Dim objWord As New Word.Application
                Dim objDoc As Word.Document
                objDoc = objWord.Documents.Open(FileName:=FileName, ReadOnly:=True)
                objDoc.Activate()
                strLine = objDoc.Content.Text
                'orgStrLine = strLine
                Do While Not bFlag
                    If InStr(UCase(strLine), "PATIENT NAME:") Or InStr(UCase(strLine), "BIRTH DATE:") Then
                        Dim intPatient, intBDay, intPatientSpace, intBDaySpace, intLength As Integer
                        Dim strPatient, strBDay As String 'temp string holders
 
                        If InStr(UCase(strLine), "PATIENT NAME:") Then
                            'To find the patient name we will trim the string down to just after the Patient Name: statment
                            'then we will find the space that follows the coma and finally the end space
                            intPatient = InStr(UCase(strLine), "PATIENT NAME:")
                            intLength = Microsoft.VisualBasic.Len(strLine)
                            strUserName = Microsoft.VisualBasic.Right(strLine, (intLength - intPatient) - 13)
                            intLength = Microsoft.VisualBasic.Len(strUserName)
                            intPatient = InStr(UCase(strUserName), "BIRTH DATE:")
                            strPatient = Microsoft.VisualBasic.Left(strUserName, intPatient - 1)
                            strPatient = Replace(strPatient, MyTab, "")
                            strUserName = strPatient.Trim
 
                            lstItem.Text = strUserName
                            lstItem.Tag = FileName
                            'lstItem.SubItems.Add = FileName
                            bFlagName = True
                        End If
                        If InStr(UCase(strLine), "BIRTH DATE:") Then
                            intBDay = InStr(UCase(strLine), "BIRTH DATE:")
                            intLength = Microsoft.VisualBasic.Len(strLine)
                            If InStr(UCase(strLine), "PATIENT ID") Or InStr(UCase(strLine), "MEDICAL RECORD #:") Then
                                'strip everthing before the date, using 11 as a offset becasue there are 11 letters in Birth Date: string
                                strBDate = Microsoft.VisualBasic.Right(strLine, (intLength - intBDay) - 11)
                                'orgStrLine = Microsoft.VisualBasic.Right(strLine, (intLength - intBDay) - 13)
                                intLength = Microsoft.VisualBasic.Len(strBDate)
                                intBDay = InStr(UCase(strBDate), MyCr)
                                'intBDay = InStr(UCase(strBDate), "PATIENT ID")
                                strBDay = Microsoft.VisualBasic.Left(strBDate, intBDay - 1)
                                strBDay = Replace(strBDay, MyTab, "")
                                strBDate = strBDay.Trim
                            Else
                                strBDate = "Not Found"
                            End If
                            lstItem.SubItems.Add(strBDate)
                            lstItem.Tag = FileName
                            bFlagBirth = True
                        End If
                            lstDocs.Items.Add(lstItem)
 
                            'Releasing the evil COM object
                            System.Runtime.InteropServices.Marshal.ReleaseComObject(objDoc)
                            objDoc = Nothing
                            'closing the hidden Word document
                            objWord.Application.Quit()
                            objWord = Nothing
 
                            lstDocs.Refresh()
 
                        End If
                        If bFlagName And bFlagBirth Then
                            bFlag = True
                        End If
                Loop
 
                IsWordFound = True
            Catch ex As Exception
                MsgBox(ex.ToString)
                IsWordFound = False
            Finally
                If Not (FileStreamReader Is Nothing) Then
                    FileStreamReader.Close()
                End If
            End Try
        End If
        Return IsWordFound
        FileContents = String.Empty
    End Function

                                  
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:

Select allOpen in new window

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-09-09 at 12:23:03ID24719263
Tags

Visual Basic

,

programming VB.net

,

VB

Topics

Microsoft Visual Studio Express

,

Microsoft Visual Basic.Net

Participating Experts
1
Points
500
Comments
27

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. ListBox, ListView items
    How to add to ListBox more than 32736 lines? without using colums
  2. VB.NET - ListBox
    I found this article, that I have been using: http://radio.weblogs.com/0110109/stories/2002/08/07/adjustingToLifeWithoutItemdata.html This is all fine, but how do I retrieve firstname and lastname when an item from the listbox is selected?
  3. Scrolling a ListBox
    I have two listboxes side by side in a VB.NET 2003 WinForm application. Both have the same number of items. I want both listboxes to behave as though they were only one listbox with two columns. In other words, if I click on one of the items in the one listbox, the correspond...
  4. Checked listbox checked items to text box in VB.NET- 5…
    Hello, I'm working on a question list for a VB.NET program. I have a list of questions from a text file that I want to read into a checked list box. (each line of the text file will represent 1 line of the checked listbox) After the questions are added to the list box the...
  5. load name of txt file into Listbox, then once clicked, strea…
    Hi experts, I'm trying to create a winform with a Listbox and a textbox. On Form1_Load, I'd like to load in all the file names of text files from a speciftic folder into the listbox; once selected from the list box... streamreads contents into textbox. Basically, Id like to...
  6. Streamreader issue reading word doc
    Hello, I'm using the following to append word documents to a stringbuilder and then set the stringbuilder to a label. I use streamreader to read the word document then append the text to the string builder... Ok, this works great for a plain text file, but not for word or rtf...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: CodeCruiserPosted on 2009-09-22 at 05:28:25ID: 25391968

You can use the Indexing Service if its running on the computer.

Here is a tutorial for ASP.NET but the actual searching code would be similar
http://support.microsoft.com/kb/820105


Also
http://aspalliance.com/1605_CodeSnip_Using_the_Windows_Indexing_Service_with_ASPNET_and_C.all

 

by: wardo123Posted on 2009-09-25 at 11:14:43ID: 25425629

Thanks for the advice CodeCruiser.  I have built an index per the MS article, and I'm still trying to get VB.net to work correctly with the index.  If I can get this to work, this is going to be an excellent solution for what I'm trying to do.  I'll write back after I've played with this a bit more.

Thanks

 

by: CodeCruiserPosted on 2009-09-26 at 02:56:19ID: 25429346

No problem. I hope this solves your problem.

 

by: wardo123Posted on 2009-09-29 at 18:50:29ID: 25455079

VB.net 2008 doesn't have the ASP features built in anymore so this is taking a while to try to get working in VB.  I am still working on this at this time

 

by: CodeCruiserPosted on 2009-09-30 at 00:57:52ID: 25456371

You need to develop a concept of the code from ASP.NET tutorials. VB.NET and C# are used to write the code behind code for ASP.NET so the code would be similar.

 

by: wardo123Posted on 2009-09-30 at 19:07:38ID: 25465501

I was hopeing that I wouldn't have to download and install the Visual Web Developer that is now needed to work with ASP.NET, so I have been trying to find a work around.  It looks like there is no such thing, so I'm just going to nhave to add more to my already overloaded laptop.  I really like the indexing itself, it is super quick and the link did a good write up on how to set this up.  I'll keep on trying.  Thanks for the help.

 

by: CodeCruiserPosted on 2009-10-01 at 00:54:59ID: 25466649

As i have been trying to clarify, the links i posted are related to ASP.NET but the code used in the links does not need to be in ASP.NET. Just copy and paste the code from .vb files into your winforms project. Or copy it from the web page itself.

This is all you need


      Dim strCatalog As String
 
      ' Catalog Name
      strCatalog = "TestCatalog"
 
      Dim strQuery As String
      strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where FREETEXT('" & TextBox1.Text & "')"
      ' TextBox1.Text is word that you type in the text box to query by using Index Service.
      '
      Dim connString As String = "Provider=MSIDXS.1;Integrated Security .='';Data Source='" & strCatalog & "'"
 
      Dim cn As New System.Data.OleDb.OleDbConnection(connString)
      Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn)
      Dim testDataSet As New DataSet()
 
      cmd.Fill(testDataSet)
 
      ' Bind DataGrid to the DataSet. DataGrid is the ID for the 
      ' DataGrid control in the HTML section.
      DataGridView1.DataSource = testDateSet.Tables(0)
                                              
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

Select allOpen in new window

 

by: wardo123Posted on 2009-10-03 at 06:45:28ID: 25485380

Hummm.. I'm not sure that I understand your last posting, it sounds like you think that this is a web page application.  This is just a standalone tool I made to allow us to search through this data.  Im not very good  at using VB.net, this is only the 2nd project I have built using VB.NET, mostly I have done scripting in some form or another for my own personal use, but in this case I needed a simple search with a complex GUI, so I built this project using VB.NET and made this into an exe running from a server for teams to use this search.

 

by: wardo123Posted on 2009-10-03 at 07:04:11ID: 25485440

I re-read this and finally I understand what you are talking about.  I had tried doing something like this before, but I wasn't doing it like you did, so let me try this again.  Thanks

 

by: wardo123Posted on 2009-10-03 at 18:05:11ID: 25487735

I still run across two issues doing it this way.  my Issues are as follows:

1) My index was built on the server that contained the actual data, and I can't seem to figure out how to connect to a remote index.  Does that mean I need to build a indentical index on my PC in order to debug this?

2) for this line "DataGridView1.DataSource = testDateSet.Tables(0)" I relize that this is supposed to load a datagrid, but I'm not sure hw to get the returned results into my ListView Box.  When I was working with a text search I would pull out the last name and First Name and put them into one column and I would take out the bithdate and put it into a second column, each row would get the file fale populated into the row tag, so that the user could double-click a row and it would open the document, but the source of the document remained hidden.  I have no idea how to pick out just the data I want

Sorry to be such a pain

 

by: CodeCruiserPosted on 2009-10-05 at 00:42:11ID: 25493104

Hi,
1) I think you need to tweak the connectionstring and add the computer name before the catalog name.
2) You can access the rows and columns in the datatable like below

For i as integer = 0 to testDataSet.Tables(0).Rows.Count
      Messagebox.Show testDataSet.Tables(0).Rows(i).Item("columnname")
Next

 

by: wardo123Posted on 2009-10-08 at 18:55:40ID: 25531868

I still haven't been able to remotly connect to the indexing database on my server.  I have been looking over other links that make it sound like I should be able to do this, but I always get no database being found.  One of the more promisisong links I have been looking out is located here http://www.codeproject.com/KB/aspnet/IndexingServer.aspx and I've tried making this work with my VB project, but no go.  I've also read a bunch of people explain how to connect to a remote SQL database, and I thought there would be a lot of difference, but so far I'm failing at this task

 

by: CodeCruiserPosted on 2009-10-09 at 00:54:25ID: 25533010

Did you act on the explanation in that link?

"You don't specify a data source when you query a catalog on a remote Indexing Server. So you just specify the provider. The name of the remote Indexing Server and the catalog are then specified in the query itself. Here is an example:"

 

by: wardo123Posted on 2009-10-09 at 19:42:24ID: 25540526

I did try the method that was listed in the link, but couldn't get it to work.  I also tried another method where you treat the database like a SQL database and then you specify the server and the database, but neither worked.  I feel that if I can make this connection I could rapidly complete this project.  So close but so far.  I didn't see your example.

 

by: CodeCruiserPosted on 2009-10-12 at 01:33:03ID: 25549369

Are you sure the indexing service is running properly and a catalog does exist?

 

by: wardo123Posted on 2009-10-12 at 16:56:30ID: 25556062

If I go onto the server I can find my data using the Indexing Service Query Form to find my data, and that works great for finding the data I need, but currently all requests for data have to go to me and then I have to logon to the server and find the data.  I don't want to give everyone access to this, so I still need to get this program to work with this data.

 

by: CodeCruiserPosted on 2009-10-13 at 00:50:56ID: 25557745

Now it does not make sense why it wont work. May be permissions issue or something else.

 

by: wardo123Posted on 2009-10-15 at 10:40:30ID: 25582826

I'm still playing with the structure of the code from the link I submitted and I'm still playing with SQL queries.  I feel I have to be just a little bit off.  After totally restructuring I am now getting and error stating that "Multiple statement commands are not supported. SQLSTATE=42000".  

Maybe I'm just way off of base as to how I'm putting in the code.  I thought I'd post what I had and you can see if I'm totally off base. I'm not sure about the query view I'm using becasue I would think that WEBINFO would imply that I'm using the Web Catalog and I don't have IIS turned on for Server3.  The Indexing catalog is named MIndex and when it get to the command.excutereader it gives me the Multiple Statements error.  My Imports statement is at the top of the form.

Imports MSearch = System.Data.OleDb.OleDbConnection
        Const ConnectionString As String = "Provider=MSIDXS;"
        Const QueryString As String = "SELECT * FROM Server3.MIndex..WEBINFO;"
        Dim Connection As MVISearch = New MSearch
        Connection.ConnectionString = ConnectionString
        Dim Command As IDbCommand = Connection.CreateCommand
        Command.CommandText = QueryString
        Command.CommandType = CommandType.Text
        Connection.Open()
        Command.ExecuteReader()
                                              
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

Select allOpen in new window

 

by: CodeCruiserPosted on 2009-10-16 at 01:02:51ID: 25587655

Try removing the semi colon at the end

Const QueryString As String = "SELECT * FROM Server3.MIndex..WEBINFO"

 

by: wardo123Posted on 2009-10-18 at 12:45:36ID: 25601102

I took the semi colon off of the line you mentioned and the Provider=MSIDXS line and now I'm back to my null database error.  I opened databse explorer in VB.NET and it browsed to the location of the actual index file nad it says it can't find a database.

I was afraid I was doing something fundamently wrong, so I'm now thinking that I'm just going to see if this works on a local index file.  If it works locally I can always put the exe file on the sever and write a .bat file that will put in truse permissions for the remote server and create a shortcut to the .exe.

With that in mind I copied a couple of hundred files from the server and put them into a folder of the same name on my computer.  I then made an identical Index catalog on my PC (with just less data).  I think I can talk to the local database (at least I'm not getting errors during the build), but whe it comes to pulling data out of the database it is failing during the lines

For i as integer = 0 to testDataSet.Tables(0).Rows.Count
      Messagebox.Show testDataSet.Tables(0).Rows(i).Item("columnname")
Next

The failure is:
Column "columnname" does not belong to table Table

I'm assuming that I should be putting replaceing columnname with something else, but I'm not sure what that should be.

 

by: CodeCruiserPosted on 2009-10-19 at 00:13:01ID: 25603062

Columnname, as the name suggests would be the name of one of the columns in the table. Try an index instead. So replace

Messagebox.Show testDataSet.Tables(0).Rows(i).Item("columnname")
with
Messagebox.Show testDataSet.Tables(0).Rows(i).Item(0)

 

by: wardo123Posted on 2009-10-19 at 13:05:07ID: 25608475

The only problem with doing it this way is that when I populate the column data with numbers it allows me to user 0-3, then when I get to 4 it errors out saying it can't be converted to a string.  When I try using 5 it says it can't find a column 5.  This leaves me with column's 1-3 and these only contain information about the file that was found.  The info is as follows:
0 - Modify Date
1 - filename
2 - file size
3 - Path & filename

None of this seems to give me any of the found data, like first name, last name, and birth date

 

by: CodeCruiserPosted on 2009-10-20 at 00:29:22ID: 25611685

This returned data depends on your query. Your query seems to be selecting from a table plainly. Try to tune up the query using the where clauses to perform the search.

 

by: wardo123Posted on 2009-10-21 at 07:09:54ID: 25624114

Well, now that I look at the query, I can see what is happening, I stole the statement from the example on the webpage you pointed me to so the query statement is:
strQuery = "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where FREETEXT('" & SearchWord & "')"

It state right in the query that we are only selecting Doc Title, Filename, Size, Path, and URL (that explains a lot.  I will now just need to figure ourt what fields are available and select the ones I want.  I'll see what I can do with this, thanks for point me in the right direction.

 

by: CodeCruiserPosted on 2009-10-21 at 07:11:52ID: 25624135

I am glad i was helpful.

 

by: wardo123Posted on 2009-10-25 at 07:37:48ID: 25656742

I think I'm limited as to what can actually be pulled from Index itself. I tried running the index staement using the following:
strQuery = "Select * from SCOPE() where FREETEXT('" & SearchWord & "')"

And when it ran I got an error stating that the wildcard wasn't allowed for this type of query, and becasue the indexing service only allows a subset of SQL queries to run I'm assuming that this is a limitation of the DB itself.

I was never able to get this program to work on a remote system, but I think I will build this on my system and copy it to the remote system, and didsributate shortcuts to each user's desktop (and at the same time adjust the PCs security permissions to allow remote code execution on this server).
I can use the Path results to feed into another sub that will pull the data out of the few document that are found.
It isn't perfect, but at least it allows me to get the job done, and that is better then I was.  I'm just going to close this item and award the point  to CodeCruiser so he doesn't have to babysit me all day long.  Tanks for the help CodeCruiser.

 

by: wardo123Posted on 2009-10-25 at 07:44:28ID: 31626785

This got me going with a lot of work arounds

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...