Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 loses links / joins

Status
Not open for further replies.

VB6Learner

Programmer
Joined
Feb 2, 2004
Messages
5
Location
US
In Access 2000, has anyone ever experienced the loss of links / joins between tables when going into Design view?

I know this can happen if a table has been deleted or modified in structure, but we regularly have problems with it even with non-changing tables in our query.

We get a message box for each link that is dropped, but no matter how we answer the messagebox (even cancel), the links are destroyed, even when we do not save changes.

Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top