After splitting database, Relationships in both Front End (FE) and Back End (BE) are Missing,

[Error404]

After splitting my database into a FE and BE, both are not displaying the relationship tables that were setup prior to the split. All forms and queries still work, so the relationships are still there, but they are not visible when you go to edit/ view them. Any ideas?

I have clicked "all relationships" and tried any other obvious fix, hoping I didn't try them all yet

db prior to split (ignore mismatched table names, db is slightly older)


db be after split



db fe after split

[June7]

Seems you aren't the only one to encounter this, although your situation seems even more bizarre.

Review http://www.utteraccess.com/forum/Los...-t2008283.html

I have never used the split tool, I manually split db.

[CJ_London]

relationships are in the back end - if the back end has been created by exporting the tables from the 'single' db, see if there is a tickbox that you can set to include the export of the relationships

[Error404]

I just repaired all the missing relationships in the BE, they now all show in FE also and nothing appears to be broken as a result.

So I literally just remade them.

If this causes errors in the future I will update this thread.

[June7]

Why do they show in frontend? I have a split db with Relationships set in BE and they do not show in the Relationships window of FE.

Do you mean when you build queries in FE the JOINs are automatically established?