Solved

Relink tables Access 2007

Posted on 2010-08-24
4
987 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views 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 Access…
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…

757 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

21 Experts available now in Live!

Get 1:1 Help Now