Hello all,
We have a payroll application that runs with MS Access. It is comprised
of several different database files and one ms access mdb file for each
client. This means there can be from 10-1000 different MDB files. We
have a web application that we designed to do various things with this
payroll application.
One of the problems is I want to be able to find what databse a
specific piece of information belongs too. For example...We have a last
name, or a social security number but we do not know which client it
belongs to. So I want to be able to type in that info and find out
which client that name or SSN belongs to.
I do not have the ability to change any settings of these
databases. I can only READ the data. I am thinking of making an "Index"
of sorts that runs every night that compiles the various information
(employee names, social Securty numbers, etc...) into XML files (one
xml file for field) that contains the client database name and the
field value. So that when a search is performed it is rather quick.
Then it can re-index every night to get the latest information. When a
match is found it displays the name of the client that it belongs too.
Does this make any sence? I am stuck at this point. I'm not sure if
this is the best way, or if I should just search each database
everytime, one at a time (zzzz)? PLEASE HELP!!!
