B,
Most small Access databases are self-contained. If you look at the
Database Window, you'll see that the tables/queries/forms/reports
all exist in the same database.
Access is flexible though and for security/performance reasons people
sometimes "split" their databases. There is a "front-end" with the
user's forms/reports/etc. The "back-end" is a seperate database that
holds only the tables.
Though they are in different .MDB files, they work together. The front
end tables are just pointers to the other databases tables.
Open an Access Database:
Select "File --> Get External Information --> Link Tables
Browse and select another Access Database
You can then choose some/all of its tables to "link".
Access will store the path to the other database name in the table's
link field. You can now use that table just like it was in your original
database (almost).
However, if you move the other database, Access can't find it!
If you move your database to someplace that can't see the other database,
Access can't find it!
Wayne
