Lost relationships after split in BE

[Z34Lee]

I saw there were several posts by people who thought they lost their relationships after a split, but that was in the front end. Mine are now gone in the back end. None of the tables are even shown in the relationship window. Just a heads up I guess.

 

[KeithG]

You can't enforce a relationship on a table that is linked. You must create the relationship in the db where the table is linked from. Are you saying you lost your relationships in the BE.

 

[Z34Lee]

Yes - split database, no relationships anymore in backend.

 

[boblarson]

When you split a database, the backend is new (hence the reason why the relationships aren't there) (the frontend just gets linked to the new backend). If you want the relationships, you need to define them in the backend.

 

[Pat Hartman]

I think it depends on what version of Access you are using. Relationships should be copied into the be when the database is split. I ran into this a number of years ago with A2K and it caused me a real problem because bad data got into the database and I looked like an idiot. So, now I ALWAYS check to make sure everything transfered properly.

 

[Z34Lee]

Just to drudge this up one more time, where SHOULD the relationships be? Front or back?

 

[Pat Hartman]

There is only one place where they can be - the back end. Think about it this way - if you created a second front end to link to the first back end, you could conceviably create RI conflicts. Which database's constraints would prevail - front end 1 or front end 2?

You can create relationships in a front end but they are for reference only. You will not be able to enforce RI. They do nothing but look pretty.

 

[boblarson]

There is only one place where they can be - the back end. Think about it this way - if you created a second front end to link to the first back end, you could conceviably create RI conflicts. Which database's constraints would prevail - front end 1 or front end 2?

You can create relationships in a front end but they are for reference only. You will not be able to enforce RI. They do nothing but look pretty.

Yay! I was right (for a change)

 

[Pat Hartman]

Don't be so modest