Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Update Tables with Relationships

Posted on 2009-05-14
4
Medium Priority
?
182 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 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

916 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