".Len B" wrote in
:

What happens when I split and the tables are in different
back ends? Am I in trouble?

Why would you do that? If the tables are sufficiently related that
it is necessary to enforce RI, then they belong in the same back-end
file. If you are splitting them up because your dataset is getting
too big, then you've outgrown Jet/ACE as a data store and should
instead use a more suitable back end, i.e., one that can handle more
than 2GBs of data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/