Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Update Tables with Relationships

Posted on 2009-05-14
4
Medium Priority
?
179 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

715 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