?
Solved

Relink tables Access 2007

Posted on 2010-08-24
4
Medium Priority
?
1,002 Views
Last Modified: 2012-06-22
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.
0
Comment
Question by:donpick
[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
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 33517654
Here is the de-facto standard:

http://www.mvps.org/access/tables/tbl0009.htm

mx
0
 
LVL 3

Expert Comment

by:SantiagoA
ID: 33526631
Why do you want to delete links? you do so to relink the tables?
0
 

Author Comment

by:donpick
ID: 33537936
SantiagoA:

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.
0
 

Author Closing Comment

by:donpick
ID: 33537954
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.
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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

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