So I have a legacy Access database. And the tables are included in the\ndatabase file. And there are bunches of relationships defined for lots\nof\nthe tables.\n\nNow I want to split the tables off into a separate file, then link to\nthat\nseparate file. I have the usual reasons for wanting to do that.\nDatabase size, sharing among multiple users, etc. Some of the\ntables are getting quite large and I may put each of those in its\nown separate file.\n\nHow can I get the existing relationships to apply to the linked\ntables?\nThat is, other than manually recreating them on the newly linked\ntable.\nI can do that, but it will take a long time. The guy who wrote the\nexisting database was very fond of adding relationships.