Remove Object Dependencies - MS Access

I have inherited an MS Access database.

I want to delete one of the object dependencies (table depends upon another table).
How do I do that?

Access 2003, SP3
Richard KortsAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Ok.

Open up the Access data
From the menu ... Tools>>Relationships ...  
Right click over a blank area of this window and select Show All.

Locate the tables in Question.  There should be a line between these two tables.
Click the link to highlight it ... then hit the Delete key (or right click and select Delete)

This should ... delete the relationship and eliminate the problem.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Are you referring to a Relationship?

mx
0
 
Richard KortsAuthor Commented:
To DatabaseMX

When I do a SQL query to Insert a record on the web server, it says this.

[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'buildings'.

When I go to MS Access, I see the attached file when I click on Object Dependencies.
obj-dep.jpg
0
 
Richard KortsAuthor Commented:
That did the job.

Thanks!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Grade:  A - "That did the job.

Thanks!"  "

you are welcome.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.