Indexing Service and Access Files

[Lyle Fairfield]

By default mdb etc files are not searched by Indexing Service.

The default can be changed in Windows XP Pro using Group Policy.
I can find no suggested way to make the change in the Windows XO Home.

I decided to try adding this Registry Key:
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Win dows\NetCache]
"ExcludeExtensions"=""
"SyncAtLogon"=dword:00000001
"SyncAtLogoff"=dword:00000001
"Enabled"=dword:00000001

I cannot report on the success of this gambit until Indexing Service has
a chance to work. (Yes, I rebooted).

I specifically recommend that you DO NOT fool with this Registry Setting
unless you know what you are doing and are willing to accept the risk .

Do you have any suggestions about other ways of solving this problem?
(The problem is NOT about searching MDB files; it is about using
Indexing Service to search MDB files.)

Do you think Indexing Service will be able to recognize and deal with
the Unicode it finds in mdb files?

Do you have any other comments?

Does your Desktop search Utility search JET files?

--
Lyle Fairfield

[Wayne Morgan]

Is the registry file you mention for the Indexing Service or for Offline
Files Synchronization?

--
Wayne Morgan
MS Access MVP
"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:4W**********@read1.cgocable.net...

By default mdb etc files are not searched by Indexing Service.

The default can be changed in Windows XP Pro using Group Policy.
I can find no suggested way to make the change in the Windows XO Home.

I decided to try adding this Registry Key:
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Win dows\NetCache]
"ExcludeExtensions"=""
"SyncAtLogon"=dword:00000001
"SyncAtLogoff"=dword:00000001
"Enabled"=dword:00000001

I cannot report on the success of this gambit until Indexing Service has a
chance to work. (Yes, I rebooted).

I specifically recommend that you DO NOT fool with this Registry Setting
unless you know what you are doing and are willing to accept the risk .

Do you have any suggestions about other ways of solving this problem? (The
problem is NOT about searching MDB files; it is about using Indexing
Service to search MDB files.)

Do you think Indexing Service will be able to recognize and deal with the
Unicode it finds in mdb files?

Do you have any other comments?

Does your Desktop search Utility search JET files?

--
Lyle Fairfield

[Lyle Fairfield]

TTBONK it's for Offline Sync but it also (it seems) controls what
Indexing Service Catalogs.

[Wayne Morgan]

Lyle,

I have it turned on to synch MDB files with my laptop (I set it using a
Domain Policy). I am also running the Indexing service with no problems. The
only thing to be aware of about synching MDB files this way is that it is
NOT a Jet synchronization, it is a copy of the entire file.

--
Wayne Morgan
MS Access MVP
"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

TTBONK it's for Offline Sync but it also (it seems) controls what
Indexing Service Catalogs.

[Lyle Fairfield]

Wayne Morgan wrote:

Lyle,

I have it turned on to synch MDB files with my laptop (I set it using a
Domain Policy). I am also running the Indexing service with no problems. The
only thing to be aware of about synching MDB files this way is that it is
NOT a Jet synchronization, it is a copy of the entire file.

Hi Wayne

Could you confirm?

Is your laptop OS Windows XP Home?

Does your Indexing Service catalog your mdb files completely, that is,
including data in tables? If you have Northwind on the machine will it
be identified by a search for the phrase, "Hungry Owl All-Night Grocers"?

--
Lyle Fairfield

[Tom van Stiphout]

On Sat, 07 Jan 2006 15:43:11 -0500, Lyle Fairfield
<ly***********@aim.com> wrote:

The way I read Wayne's comments he's on a different track than you
are: he is talking about synchronization while you are talking about
indexing.
I think it's asking a lot of Index Server to index MDB's contents.
Where does it stop? Apparently you would expect it to find some data
for you. How about the value of some property of some object? A
keyword in the VBA code? What about databases protected with Access
security?
If it isn't available for SQL Server, I sure don't think it's
available for Jet.
Perhaps IS has the ability to write extensions for it?

-Tom.

Wayne Morgan wrote:

Lyle,

I have it turned on to synch MDB files with my laptop (I set it using a
Domain Policy). I am also running the Indexing service with no problems. The
only thing to be aware of about synching MDB files this way is that it is
NOT a Jet synchronization, it is a copy of the entire file.

Hi Wayne

Could you confirm?

Is your laptop OS Windows XP Home?

Does your Indexing Service catalog your mdb files completely, that is,
including data in tables? If you have Northwind on the machine will it
be identified by a search for the phrase, "Hungry Owl All-Night Grocers"?

[Lyle Fairfield]

Tom van Stiphout <no*************@cox.net> wrote in
news:0v********************************@4ax.com:

On Sat, 07 Jan 2006 15:43:11 -0500, Lyle Fairfield
<ly***********@aim.com> wrote:

The way I read Wayne's comments he's on a different track than you
are: he is talking about synchronization while you are talking about
indexing.
I think it's asking a lot of Index Server to index MDB's contents.
Where does it stop? Apparently you would expect it to find some data
for you. How about the value of some property of some object? A
keyword in the VBA code? What about databases protected with Access
security?
If it isn't available for SQL Server, I sure don't think it's
available for Jet.
Perhaps IS has the ability to write extensions for it?

-Tom.

Tom

I had thought this might be helpful for the situation described in this
post:
http://groups.google.ca/group/micros...rk.aspnet/msg/
6ce8e8512a334e3c


--
Lyle Fairfield

[David W. Fenton]

Tom van Stiphout <no*************@cox.net> wrote in
news:0v********************************@4ax.com:

The way I read Wayne's comments he's on a different track than you
are: he is talking about synchronization while you are talking
about indexing.
I think it's asking a lot of Index Server to index MDB's contents.
Where does it stop? Apparently you would expect it to find some
data for you. How about the value of some property of some object?
A keyword in the VBA code? What about databases protected with
Access security?
What's the issue? It's full-text indexing. Google indexes things
that are noise words from the standpoint of some searches, but we
don't consider that a problem with it. It's just in the nature of
full-text indexes that they index more than just the mere content of
the files.

As to security, there should be no issue except for an encrypted
MDB, which would not have anything visible to be indexed that would
actually be meaningful.
If it isn't available for SQL Server, I sure don't think it's
available for Jet.
Well, there's a big difference between the way Jet and SQL Server
store their data. MDBs are just files, so why shouldn't they be
indexed as mere files? No, it's not nearly as useful as full-text
search within a db engine (where you can pick a column to search,
for instance), but it's better than having no access to the
information for searching at all.
Perhaps IS has the ability to write extensions for it?

I don't see how you could build anything particularly useful without
it being supported by the db engine explicitly.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Lyle Fairfield]

David W. Fenton wrote:

I don't see how you could build anything particularly useful without
it being supported by the db engine explicitly.

This isn't particularly useful and it's not mature code and since I was
lucky enough to write it the first time without errors the error handler
has never been run.

Yes, I know it's not likely to work for 100 meg dbs, or dbs opened
exclusively and that one might have to understand about folders and Dir$
etc to use it.

But, if you can't remember in what db you saw "Bólido Comidas
preparadas" it might help by pointing out that it's in Northwind.mdb.

Function FindStringinFileType( _
ByVal skelton As String, _
ByVal findwhat As String) As Variant
Dim buffer As String
Dim filenumber As Integer
Dim foundin As String
Dim path As String
path = Dir$(skelton)
While Len(path) <> 0
filenumber = FreeFile()
Open path For Binary As #filenumber
buffer = String(LOF(filenumber), vbNullChar)
Get #filenumber, , buffer
If InStr(buffer, findwhat) <> 0 Then _
foundin = foundin & "|" & path
Close #filenumber
path = Dir$()
Wend
FindStringinFileTypeExit:
If Left$(foundin, 1) = "|" Then _
foundin = Mid$(foundin, 2)
If Len(foundin) > 0 Then
FindStringinFileType = Split(foundin, "|")
Else
FindStringinFileType = Array()
End If
Close
Exit Function
FindStringinFileTypeErr:
With Err
MsgBox "Error Number: " _
& .Number _
& vbNewLine _
& .Description, _
vbCritical, _
"FindStringinFileType"
End With
Resume FindStringinFileTypeExit
End Function

Sub test()
Debug.Print Join(FindStringinFileType("*.mdb", "Bólido Comidas
preparadas"), vbNewLine)
End Sub

--
Lyle Fairfield

[Lyle Fairfield]

After glancing at the Indexing Service and doing a Web and Usenet
search I think I was confused in thinking that the
NetCache\ExcludeExtensions settings controlled which files Indexing
Service ignored. I am SURE I saw this described at
http://hallucinations.nut but I can find it no more.

For anyone interested in this I offer the only promising lead I have
found:

http://desktop.google.com/plugins/i/accesscrawler.html

This runs, AFAICT, within Google Desktop Search. I have tried the
Google Desktop Search and rejected it in favour of Copernic Desktop
Search which I have found to be less intrusive and less demanding.

[Wayne Morgan]

No, Home Edition won't do the off-line file synchronization. I tied looking
for text I know to be in mdb files, unsecured and unencrypted mdb files, and
the mdb files weren't returned as possible results of the search. However, I
have not tried to tell the indexing service to index mdb files unless, as
you mentioned, the registry key you listed controls that as well as the
off-line file synch.

--
Wayne Morgan
MS Access MVP
"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:zJ************@read1.cgocable.net...

Could you confirm?

Is your laptop OS Windows XP Home?

Does your Indexing Service catalog your mdb files completely, that is,
including data in tables? If you have Northwind on the machine will it be
identified by a search for the phrase, "Hungry Owl All-Night Grocers"?