how to select or link a few tables on different databases.
Ex : table A on database_A , table b on database B, table c on database_C.

jlnash

In the Access XP menu, click FILE > GET EXTERNAL DATA > LINK TABLES and choose the database you need. Next pick out the table(s) you need. Repeat the process for databases stored in other locations. I think it's the same for Access 2000.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division