Error when splitting an access db

[Birdman895]

I have created a db for a nonprofit counseling org. I had created the first half, mostly administrative tasks, called Phase1, and put the BE on a network drive and the FE on multiple users.
Now in developing the clinical portion, Phase2, I linked to four of the tables in Phase1 BE file. Now I tried to split Phase2 the same way as Phase1 and got an error "Subscript out of Range". I think because of already having some external links in it.
I checked for the file and Access actually created the BE file for the new phase2, all of the tables are in it minus the four I was linking to. But, access didn't create a FE file. The original still has all of the objects, tables and forms etc.
My question is; can I link to the tables in the new BE file even though those tables still exist in the original file?
Sorry about writing a letter,,
Help!

 

[Beetle]

First, make a backup of your current file. Next, delete the tables that are still in your "front end" file, then link to the tables that you need from the second back end file that was created. Go back and link again, this time to the 4 tables from the first back end file. Test to make sure everything works as expected.

 

[Birdman895]

Hi,
If I delete the tables the way you're saying, won't all of the associated objects (forms, query's etc) end up down in "Unrelated Objects"? I'll have to reconnect all of them to the new table links.
I guess at this point it's collateral damage?

 

[Beetle]

No, the tables in the second back end that you say got created when you tried to split should have the same names as the the local tables that are still in the original app (I'm assuming anyway, you said that it created a BE file so that should have your tables in it).

As long as those tables do exist in the second BE file with the same names, then when you delete the local tables and relink to those tables in the other BE file, then all of your existing objects (queries, forms, reports) will still work as expected. As far as the basic operation of the front end objects goes, it really makes no difference whether the tables are local or linked as long as they exist.

 

[Birdman895]

Thanks! That got it.
But, all of the objects did become unrelated. So I opened each one in design view and saved it, and it was related again.
Could I have just closed the database and reopened it?
Once again thanks