Can I link 2 databases in Access, is this possible if they
have tables in common.
Thanks again in anticipation.
Please explain what kind of link you have in mind.
You can certainly use File... Get External Data... Link on the Menu to
link two databases, so that queries and forms in one database can use
data which resides in tables in a different database; in fact this is
routine good practice.
If on the other hand you have "tables in common" - the same data
stored in two different .mdb files - you may be in trouble! Redundant
data storage is NEVER a good idea.
Where are you starting from, and what do you want to accomplish? More
details please!
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
