V
Van T. Dinh
This sounds like the set-up one of my clients had when I
first did some work for this client. The client has over
250 databases, one for each of his customers.
It is a wrong set up, though. It is more appropriate to
consolidate all data into one MDB file in general. You
will need to add extra Fields/Tables to "classify" Records
in the consolidated MDB file so that you can select
Records the way your office works. For example, you may
want to add the Field "TransYear" (or "TransDate") in your
Tables so that you can select Records by year (or date).
Unfortunately, this may take some time for you to re-
design / modify the Tables and consolidate the data as
well as queries and Reports.
HTH
Van T. Dinh
MVP (Access)
first did some work for this client. The client has over
250 databases, one for each of his customers.
It is a wrong set up, though. It is more appropriate to
consolidate all data into one MDB file in general. You
will need to add extra Fields/Tables to "classify" Records
in the consolidated MDB file so that you can select
Records the way your office works. For example, you may
want to add the Field "TransYear" (or "TransDate") in your
Tables so that you can select Records by year (or date).
Unfortunately, this may take some time for you to re-
design / modify the Tables and consolidate the data as
well as queries and Reports.
HTH
Van T. Dinh
MVP (Access)