We are working on putting together a network of Access DBs for a few projects at work. Our plan was to have a "Master" DB with, for instance, a table that has a list of departments and their passwords, then have all our other DBs link to that table so that any changes in the Master table will automatically update across all the rest. The problem with this strategy, we just realized, is that when you try to set up a relationship between a table and a linked table, you can't enforce referential integrity. Any way to get around this?
Comment