>In this shop we use Access to do just what you are talking about. Access
>prompts if we want to save changes when we close the window and they are
>and present the next time we open the relationship... May just want to try
>again and watch the prompts/keystrokes...
It's strange. Several of the relationships are there, but any new ones I
create are lost after I save and close the window. The tables I set it to
display are still shown, but the relationships are gone. I figured this
might be a known bug, so I installed the Office 97 Service Pack 1, but that
didn't seem to help.
My process: I set up the linked tables and then go into Tools|Relationships.
Most, but not all, of the tables are shown (whichever ones Access decides
you want, I guess). At this point, there are several relationships shown,
though there is no difference as far as I know between those and all the
others. I tell Access to display the rest of the tables, and then since it
apparently doesn't know about the table relationships in SQL Server, I
create the relationships by drag-and-drop (there are around 30 or so). I
click the Save button, close the window, open Tools|Relationships again, and
the tables are still there but the relationships are gone.
Am I missing something obvious here?
JMU Technical Services