Missing Relationships

  • Thread starter Thread starter Laura
  • Start date Start date
L

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,

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
 
Back
Top