Solved

Relink tables Access 2007

Posted on 2010-08-24
4
988 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
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now