Relink tables Access 2007

I have 2 files for my Access projects; one contains programs (and has linked tables to the one containing tables)  the other conrtains all the tables and queries.  I often have to relink the "front database"  .  I'm sure others have done the same.  I have to manually right click each link to delete the link.  Relinking is easy; it's the removal of links which is tedious.  

How can I delete the links quickly using the qui front end?  Or do I need to write code to do this?

Thank you for your help.
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Here is the de-facto standard:

Why do you want to delete links? you do so to relink the tables?
donpickAuthor Commented:

Yes, I have 2 Access files.  Tables are in one and programs in the other. Linking provides a way to control the tables in the "backend " database.
donpickAuthor Commented:
Thank you for the code.  I will use it somewhere

The answer I was looking for was this:
Arranage the objects by object type using the GUI interface.  Click on the top linked table.  Hold down the shift key and click on the bottom table.  Now press delete button.  All linked tables are gone.  Relink.
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.