Hi

First time user of this, so here goes!

Have recently upgraded to Access 2002. My orignal dbase was version 97.

Seems to have converted everything ok except I cant see my relationships.

I have 2 databases, a tables database holding my tables with correct relationships. My second dbase holds all the objects and identifies the tables databse through the linking option.

The curious thing is on my single user copy within my objects dbase all the relationships are clearly shown. However, on networked version (MS Server 2002) I cannot see the relationships in obects dbase?

I don't know how to fix this or where to look for answers? any suggestions??

You should be able to see the relationships if you open the be db directly. If they are ok, then they are being enforced even though you may not be able to see them in the fe db.

Open the fe db, relationships window. Add all the linked tables. The relationships should appear as the tables are added to the view.