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


VB Petition

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.

1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer