How to set up a script to search for specific string?

[rxjeff]

Hi All

I have very little programming background and was recently asked to make sure that our MS Access databases (over 60 of them) do not contain any unencrypted info.

I'm sure there's got to be a faster way to do this than to log into each database and manually look for it?! The string is on a particular table and in a particular field, so if anybody can point me in the right direction would be great. I was hoping to write a little script to allow it to log into the MDB database and search in a particular table and field for 16 or more consecutive numbers. If found, then it would output a report showing:

Database1 found in location x:\database1\blah\
Datbase5 found in location x:\database2\blah
.
.

That way, it would save me time from trying to look into every one of my databases manually.

Any help would be appreciated!!

 

[Remou]

If you are looking in tables, you can use a Workspace:

Dim ws As Workspace
Dim db As Database

Set ws = CreateWorkspace("JetWorkspace", "admin", "")

Set db = ws.OpenDatabase("C:\Docs\Tek-Tips.mdb")

For Each t In db.TableDefs
<...>