Charlotte Foust
cfoust at infostatsystems.com
Wed Jul 9 15:15:35 CDT 2003
It can't be done directly. Referential integrity can only be enforced within the database that houses the tables, not between databases. The best you could do would be to write code and use queries for this purpose, but it won't be foolproof. Charlotte Foust -----Original Message----- From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] Sent: Wednesday, July 09, 2003 12:05 PM To: accessd at databaseadvisors.com Subject: [AccessD] Referential Integrity Is it difficult to enforce referential integrity across 2 (or more) backend MDBs? I want to take some tables that are common to 2 systems out of one back end MDB and put them in a separate backend MDB, but still enforce RI across both back-ends. Stephen Bond Otatara, New Zealand _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com