Relationship different in FE and BE database

[Dophia]

Hi Everyone:
I have an Access 2003 database with a front end and a back end. I need to change the tables relationship. I can add the new relationship in the back end, but when I open the front end and re-link the tables, it doesn't show the relationship. How can this be accomplished?

Sophia

 

[dhookom]

What did you try in order to update your front end mdb? Did you try click the Show All relationships button?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Dophia]

Now that I look back, the relationship was already established and the "enforce referential integrity" was already "checked" but I wanted to add the "cascade delete related records".

Yes, "show all" is checked. When I open the BE, it shows the option as checked, but when I open the FE it does not show the option as checked and I can't check it.

Sophia

 

[dhookom]

YOu can't enforce any relationships in your front-end. All relationships must be maintained in the back-end and should/can be displayed in the front-end.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Dophia]

Yes, I know, but for some reason it is not showing in the front-end.
Sophia