Access on NT Network

[kevinh]

I have Access 97 data tables on an NT 4 server, and the frontend on NT workstations. I added a new table to my data file, created the proper relationship and join lines. I linked the new table to my frontend on a workstation. However, on the workstation, the relationship between the tables does not show up in the QBE grid when I try to create queries. The relationship line does show up on the frontend on the server and, interestingly, on frontend on a Windows 98 laptop that I hooked up to the network. <br>
<br>
Does anyone know what is going on here? Why do I have a problems with table relationships and referential integrity from an NT workstation and not from a Windows 98 workstation or on the server itself?

 

[elizabeth]

I don't know why but do you show all tables and relationships in the db relationship window of both the fron and back end?? If not try the Relationships/Show All. Also I build my relationships in the back end and I find I lose my layout (I move the tables around for a better visual) in my front end whenever I compile it or refresh it ( I forget which). So you might try either of those. Good luck