How do I link databases

R

RS

I am pretty new to access and I want to link three to four databases and I
assume it is done through the ID number. Is this correct. I have tried this
but when I change something in the main database nothing changes in the
others and my objective is that information will change in all databases when
I change something in the main one. Can I do this.

Please help me somebody.
 
N

Nikos Yannacopoulos

I understand you are confusing "databases" with tables? A database is made
up of multiple tables and, in Access, it mostly contains additional objects
too, like queries, forms, reports etc (in Access all of this is stored into
a single file, mostly referred to as the database).

Having cleared this, what you are describing is table joins. To get this
kind of behaviour, you must define relationships between tables in your
database (Tools > Relationships), Enforce Referential Integrity and Cascade
Update Related Fields.

HTH,
Nikos
 
Top