Anyone know how to break the link in a MS Access 97 table w/o deleting the table? Exporting and copying retain the link. (I would like to move the table to a new area, without the link.) I have run out of options, and might be overlooking something. Thanks for the help.
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Breaking Access Table Link (Access 97)
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Breaking Access Table Link (Access 97)
- This topic has 10 replies, 6 voices, and was last updated 22 years, 4 months ago.
AuthorTopicWSupstate518
AskWoody LoungerFebruary 13, 2003 at 2:10 pm #383310Viewing 0 reply threadsAuthorReplies-
WSHansV
AskWoody LoungerFebruary 13, 2003 at 2:18 pm #653201I don’t understand – what do you mean by “I would like to move the table to a new area, without the link”?
If you mean that you want to replace a linked table by a table actually residing in your database (the way you can unlink a linked Excel table in a Word document, so that it becomes an embedded object), I have to disappoint you – there is no way to do that. You’ll have to delete the link and import the table from the source database.
If you mean that you want to move the source table to another location without breaking the link, you can use the Linked Table Manager – in Access 97, it is an add-in (Tools/Add-ins). It can also be done in code – the Solutions and Order sample databases that come as with Access 97 have startup code to check, and if necessary repair the links to Northwind.mdb.
-
WSupstate518
AskWoody Lounger -
WSHansV
AskWoody LoungerFebruary 13, 2003 at 2:46 pm #653212I’m sure I’m dense, but I still don’t get it.
Say you have a physical table in database A. Database B contains a link to this table.
Now, you want to move the physical table to a new database C. This effectively breaks the link in database B – it still points to A, so it has become invalid.
If you don’t want to use the link any more, delete it from B; this has no effect at all on the physical table (now in C).
If you still need the link, refresh it using the Linked Table Manager – it will allow you to point the link to C, so that it is a valid link once more.
On the other hand, if you want to move the link from B to C, you can do that in two steps – copy it to, or import it into C, then delete it from B. There is no way to move a link to another database in one step.
Otherwise,
-
WSupstate518
AskWoody LoungerFebruary 13, 2003 at 3:22 pm #653219QUOTE: “This effectively breaks the link in database B – it still points to A, so it has become invalid.”
This is the problem. I want the table in a new location, but I DO NOT WANT ANY LINKS whatsoever to the new .mdb. No matter what I try, the links remain. (Save as, Export, Copy) I have to create a new app. based on information in the old table, but I want to break the link so they are independant of each other.
The short question is: How do you break / remove a link between tables in MS Access 97???????????????
Thanks again for your help.
-
WBell
AskWoody_MVPFebruary 13, 2003 at 3:40 pm #653225I think you are getting tangled up in semantics. As I understand what you are asking, you want to create a new database which has a local copy of a linked table. In order to do that, you must import the table from the database that actually contains the table (often referred to as the back-end in a split database arrangement). As you’ve discovered, if you try to copy the table from the “front-end” where the table is linked, you simply get the link. A final question – is the actual table in another .mdb database, or is it some sort of ODBC link such as FoxPro, or dBase, text file, Excel workbook, etc?
-
WSupstate518
AskWoody LoungerFebruary 13, 2003 at 3:54 pm #653230Sadly, it has to remain in Access 97. I am just trying to find a way to replicate the table (w/o a link) and not have to re-enter all the info. The current setup is split between 2 different network drives. (1 for the .mde, 1 for the backend)
God, I wish I was a programmer, and not just using macro’s and expressions.
-
WSpatt
AskWoody Lounger -
WBell
AskWoody_MVPFebruary 13, 2003 at 9:38 pm #653374I take it the data is in an Access 97 database now, so why is it an issue that it has to remain in Access 97. Even if you are using 2000 or 2002, they can save in the Access 97 format. And being split between two network drives shouldn’t be an issue. All you need to do is create an empty database on the local hard drive and then import the desired table from the backend. I think we must be missing an important detail here.
-
WScharlotte
AskWoody LoungerFebruary 14, 2003 at 3:58 am #653514If you import the table from the back end, you will get all the records. However, if you change anything, that back end database will not be updated. If you’re trying to do some kind of briefcase replication, give us the specifics. That would require replicating both front and back ends, not just importing tables.
-
WSaccdb
AskWoody Lounger
-
-
-
-
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
MS-DEFCON 3: Businesses must tread carefully
by
Susan Bradley
2 hours, 38 minutes ago -
McLaren Health Care says data breach impacts 743,000 patients
by
Nibbled To Death By Ducks
3 hours, 10 minutes ago -
WhatsApp banned on House staffers’ devices
by
Alex5723
4 hours, 26 minutes ago -
Is your device eligible?
by
Susan Bradley
6 hours, 10 minutes ago -
Windows 11 Insider Preview build 26200.5661 released to DEV
by
joep517
12 hours, 21 minutes ago -
Windows 11 Insider Preview build 26120.4452 (24H2) released to BETA
by
joep517
12 hours, 22 minutes ago -
Hello Windows…My Problem is Windows Hello…
by
rdleib
13 hours, 38 minutes ago -
New Canon Printer Wants Data Sent
by
Win7and10
13 hours, 56 minutes ago -
I set up passkeys for my Microsoft account
by
Lance Whitney
3 hours, 26 minutes ago -
AI is for everyone
by
Peter Deegan
13 hours, 29 minutes ago -
Terabyte update 2025
by
Will Fastie
7 hours, 32 minutes ago -
Migrating from Windows 10 to Windows 11
by
Susan Bradley
3 hours, 5 minutes ago -
Lost sound after the upgrade to 24H2?
by
Susan Bradley
1 day, 12 hours ago -
How to move 10GB of data in C:\ProgramData\Package Cache ?
by
Alex5723
2 hours, 34 minutes ago -
Plugged in 24-7
by
CWBillow
22 hours, 40 minutes ago -
Netflix, Apple, BofA websites hijacked with fake help-desk numbers
by
Nibbled To Death By Ducks
2 days, 1 hour ago -
Have Copilot there but not taking over the screen in Word
by
CWBillow
1 day, 23 hours ago -
Windows 11 blocks Chrome 137.0.7151.68, 137.0.7151.69
by
Alex5723
3 days, 16 hours ago -
Are Macs immune?
by
Susan Bradley
8 hours, 31 minutes ago -
HP Envy and the Function keys
by
CWBillow
3 days ago -
Microsoft : Removal of unwanted drivers from Windows Update
by
Alex5723
18 hours ago -
MacOS 26 beta 1 dropped support for Firewire 400/800
by
Alex5723
4 days, 4 hours ago -
Unable to update to version 22h2
by
04om
1 day, 12 hours ago -
Windows 11 Insider Preview Build 26100.4482 (24H2) released to Release Preview
by
joep517
4 days, 12 hours ago -
Windows 11 Insider Preview build 27881 released to Canary
by
joep517
4 days, 12 hours ago -
Very Quarrelsome Taskbar!
by
CWBillow
3 days, 21 hours ago -
Move OneNote Notebook OFF OneDrive and make it local
by
CWBillow
5 days, 1 hour ago -
Microsoft 365 to block file access via legacy auth protocols by default
by
Alex5723
4 days, 13 hours ago -
Is your battery draining?
by
Susan Bradley
19 hours, 39 minutes ago -
The 16-billion-record data breach that no one’s ever heard of
by
Alex5723
1 day, 13 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.