Solved

Access Update Tables with Relationships

Posted on 2009-05-14
4
167 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

770 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