I have two _be databases on different networks, I can access both, they were seperated due to slow processing. They have identical structure, just different data. I need to query this information as a whole. Is there a simple way to do this. Can you pull the information from each database into new tables in a master database. Can you query them by linking tables. I need help any suggestions would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
query from two identical databases
- Thread starter rooterr
- Start date
BlackKnight
Programmer
Hi,
I assume you still want to keep the dbs separate? If it was slow there's probably no point in reuniting them as one table so...
I would suggest creating a union query that would union a query that pulls recs from a tableA in database1 with a query that pulls recs from a tableA in database2.
SELECT * FROM tableA in 'N:\db1.mdb' UNION SELECT * FROM tableA in 'N:\New\db2.mdb'
Have as good one!
BK
I assume you still want to keep the dbs separate? If it was slow there's probably no point in reuniting them as one table so...
I would suggest creating a union query that would union a query that pulls recs from a tableA in database1 with a query that pulls recs from a tableA in database2.
SELECT * FROM tableA in 'N:\db1.mdb' UNION SELECT * FROM tableA in 'N:\New\db2.mdb'
Have as good one!
BK
- Status
Similar threads
- Locked
- Question