Find a Value in an Access MDB

CynthiaBlue

New member
Local time
Today, 15:43
Joined
Mar 22, 2011
Messages
2
I've been searching all day and am not finding an answer... I have a very large Access MDB and I need to find a particular value inside. Could be in any field in any table (there are probably 100 tables).

Too much too look through visually.

Is there any way to do this? I don't know much about macros or how to use VB but I can learn.

Specifically, I'm trying to find the Employee ID Number. My coworker has told me that he's looked through every table, every field, manually and cannot find it. I guess it could be encrypted, but there's not really a reason to encrypt it. It's public information, not an SSN.

I don't know what the field name will be. But I do have some EINs that I can search for that I know are in the MDB.

The MDB holds information for an application called iLink. This EIN is a field created by the iLink user, in iLink. I need it for linking purposes to other tables in other databases.

I'd love help thanks!
 
You were searching all day -- what have you tried?
 
I've been searching for solutions all day... I refuse to have to look through every table. :p

Right now I'm trying to export all the tables, and then doing a Find in Files in Ultra Edit. I love Ultra Edit.
 

Users who are viewing this thread

Back
Top Bottom