Front End doesn't load if back end is missing

[James Deckert]

I'm trying to implement the J Street Relinker on a db which has just been split into FE/BE. I've used the relinker on another db and I don't think the problem is the relinker.
If I rename the BE, then when loading the FE, I get the Access attached screen as if no db was loaded.

If I select the db on the left of this screen I go to the "New" screen to allow me to create a new db. I'm using Access 2016, but I tried this same thing (renaming the BE) on my other db and the relinker popped up with a browse screen to allow me to choose the BE, which is what I want for the new db.
The new db was originally set up to load the splash page in the Options>Current Database>Display Form. My old db used an AutoExec macro to load the splash page and relinking code so I changed the new db to use an Autoexec macro, which runs fine if the BE is where it should be, but goes to the previous pic if there is no BE. I've put a msgbox as the first line in the Autoexec Macro and it doesn't display if the BE is missing, but pops up fine if the BE is available.
I also loaded the FE by dbl-clicking the FE from the HD just to make sure there was no difference, and the same thing happened.
Any ideas on what is going on that my code is not executing if the BE is missing? I just recently inherited this db, so I didn't develop it.

 

[HiTechCoach]

I have not used the J Street Relinker. I wrote my own back in the mid 1990's and still use it today.

Without seeing the actual code being executed it is impossible to say.

When and how are you testing for the existence of the back end?

 

[James Deckert]

Thanks Boyd,
The problem was not with any code.

I narrowed the problem down to something in one of 4 tables. But if I create a new db and import all objects, then import the 4 tables, this seems to fix the problem.

 

[HiTechCoach]

Thanks for the update and sharing your solution.

Sounds like a corrupted back end.

Please Read: A message to forum cross posters

Cross posted here: http://www.accessforums.net/programming/problems-after-linking-tables-sql-access-2007-a-56731.html

 

[James Deckert]

Thanks Boyd for the feedback on crossposting. I regularly look at 4 different Access forums and had posted at the other with no response for a couple of hours, so decided to try here also. I should have included my original link

I knew to mark the thread solved. It is frustrating to be working on something which has been solved by someone else, but I've had that happen on a single forum. Someone posts 3 minutes before you after working on a problem for 15.

Anyway, thanks again.