Stephen Bond
stephen at bondsoftware.co.nz
Wed Jul 9 15:21:02 CDT 2003
That's what I suspected. Thanks, Stephen Bond -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Thursday, 10 July 2003 8:16 a.m. To: Access Developers discussion and problem solving Subject: RE: [AccessD] Referential Integrity 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com