Solved

Access Update Tables with Relationships

Posted on 2009-05-14
4
163 Views
Last Modified: 2013-11-29
In updating Access tables, I often am required to break relationships before a table can be updated (i.e. adding/deleting or formatting fields).

This has not been a problem thus far, but as the database grows in complexity I am gathering suggestions on how other Experts manage updating tables when there are numerous relationships embedded.

Thanks.
0
Comment
Question by:tahirih
  • 2
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
Michael Vasilevsky earned 500 total points
ID: 24386923
Hmm I wonder why you're having to break the relationships. In general your database architecture should be pretty static and you should only have to break a relationship if you're deleting a field that the relationship is built on, and in the case you wouldn't want the relationship anymore anyway.

Maybe you could provide some more info/examples?
0
 

Author Comment

by:tahirih
ID: 24386951
I have been deleting fields that the relationship was built on, so it makes sense that I am prompted to remove the relationship first.

Are there any other methods to effectively modifying the data without breaking the relationship?

Thanks
0
 

Author Closing Comment

by:tahirih
ID: 31581547
Thanks
0
 
LVL 10

Expert Comment

by:Michael Vasilevsky
ID: 24389133
You mean modifying the design of the tables and relationships? I don't see why you would regularly want to modify this. Your database architecture should not change one you're complete with design. Maybe if you provide some examples I can give more specifics...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now