donpick
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why do you want to delete links? you do so to relink the tables?
ASKER
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.
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.
ASKER
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.
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.