Tables: Referential Integrity between databases

Home | French | About | Search | mvps.org


	What's New Table Of Contents Credits Netiquette 10 Commandments Bugs Tables Queries Forms Reports Modules APIs Strings Date/Time General Downloads Resources Search Feedback mvps.org In Memoriam Terms of Use

Tables: Referential Integrity between databases	Author(s)
	Dev Ashish


(Q) How can I set referential integrity between my tables and tables in attached databases? (A) Access won't set up default relationships or check referential integrity between attached databases of any sort. You'll have to handle any such requirements in code, or import the files instead of attaching them. Note that you can set up "on-the-fly" relationships in queries involving attached tables as necessary, just by dragging the linking fields from one table to another.