Question Linking 2 databases and running queries

[tucker61]

I have had a access 2003 database running for over 12 months. Size is only 10 mb but networking team say it is too big and I must shrink it down.

I have 3 people inputting into database. All have their own front end on desktops.
I was thinking of creating 3 separate back ends so that they all have a complete database on their own.
For the purpose of my reports I want to combine all data.

All fields are called exactly the same.
But they contain unique data records.

Exampe.
Tables all called data. Field called job_no
Database a has job no A1, a2,a3
Database b has job no's b1,b2,b3
Batabase c has job no's c1,c2,c3

I want a query that will bring back data from field called job_no from all databases.

So result should look like this.
Job_no
A1
A2
A3
B
B2
B3
C1
C2
C3

Please let me know your thoughts

Regards
Tucker61

 

[gemma-the-husky]

10Mb is tiny

how can 10Mb give them any sort of network problem?

go back to your IT people -= get your boss to go to your IT people

tell them they are screwing up mission critical data etc etc

 

[MSherfey]

Won't a UNION query get you what you need (if IT won't pull their heads out that is)?

SELECT [Data A].[Job_no] FROM [Data A]
UNION
SELECT [Data B].[Job_no] FROM [Data B]
UNION
SELECT [Data C].[Job_no] FROM [Data C];

 

[Scooterbug]

I agree with gemma....my main backend database is over 150MB, and no network problems here. Have you asked your IT guys why they think 10MB is too big?