Hi All...
I have a database for each of last 4 years .....categories are similar but data varies
they are at its limit , so combining them is not in order
How can I have a query that goes thru all 4 at same time?
thxs
Hi All...
I have a database for each of last 4 years .....categories are similar but data varies
they are at its limit , so combining them is not in order
How can I have a query that goes thru all 4 at same time?
thxs
Have you done a Compact and Repair on the databases?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
My guess is that you're storing attachments in tables. That would be the wrong approach. If that is the case, one db with a text field that stores the attachment path is the way to go.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Do the four databases contain ONLY tables?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Bob...yes to both
Just how big are they?
How many tables in each?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
The DB size is just over 1 gig each
3 tables to each
about 265000 lines of info in each
Its a horseracing database ....factors are the same but values change
Have you tried creating a new db and linking to the tables in the other DB's rather than importing the tables?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick