Missing Relationships

[Laura]

I have an Access 2003 FE/BE application. I have password protected my
backend database. When I link the tables on my front end I should be able
to go to Relationships and Show all relationships and see the relationships
from the back end database. It shows me nothing. When I look in the Linked
Table Manager, I see a checkbox, an arrow, ?, table name, path of database.
If I try to refresh the link and prompt for new location it shows MSAccess()
as file type instead of the normal Microsoft Access(*.mdb) file type. My
concern is that the relationships on the Back end are not being enforced on
the front end because of the inability to show the relationships.

 

[Chris O'C via AccessMonster.com]

If you open the back end, open the Relationships window, right click and
click on "Show All" and no relationships appear after scrolling all the way
up and down, left and right, you have no relationships. Another way to
verify is to open the system table sysrelationships. If there are no rows,
the db has no relationships.

Recreate the relationships.

Chris
Microsoft MVP

 

[Laura]

Chris,

I can see the relationships in the Back end and they work just fine there.
If I take password protection on the backend database off and link the
tables to the
Front End. I can go to the relationships window and see all my
relationships. They are not neat and tidy as they are in the backend
but they are there and I can see them. The problem happens only when I
password protect the Back End database. When I do that and link the tables
(using the password) in the Front End, go to the relationships window, click
show all relationships and nothing appears.

Laura

 

[Chris O'C via AccessMonster.com]

Your db is fine.

Relationships can only be enforced on tables in the same database file. You
can't enforce relationships on links. Whatever relationships you've drawn on
links in the front end do nothing for you. It's the relationships in the
back end (where the tables are) that prevent orphan records.

Chris
Microsoft MVP