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. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
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, 3 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
-
Windows 11 ad from Campaign Manager in Windows 10
by
Jim McKenna
12 hours, 1 minute ago -
Small desktops
by
Susan Bradley
1 hour, 11 minutes ago -
Totally disable Bitlocker
by
CWBillow
6 hours, 52 minutes ago -
Phishers extract Millions from HMRC accounts..
by
Microfix
20 hours, 40 minutes ago -
Windows 10 22H2 Update today (5 June) says up-to-date but last was 2025-04
by
Alan_uk
22 hours, 32 minutes ago -
Thoughts on Malwarebytes Scam Guard for Mobile?
by
opti1
1 day, 1 hour ago -
Mystical Desktop
by
CWBillow
1 day, 1 hour ago -
Meta and Yandex secretly tracked billions of Android users
by
Alex5723
7 hours, 11 minutes ago -
MS-DEFCON 2: Do you need that update?
by
Susan Bradley
6 minutes ago -
CD/DVD drive is no longer recognized
by
WSCape Sand
1 day, 17 hours ago -
Windows 11 24H2 Default Apps stuck on Edge and Adobe Photoshop
by
MikeBravo
1 day, 19 hours ago -
North Face and Cartier customer data stolen in cyber attacks
by
Alex5723
1 day, 18 hours ago -
What is wrong with simple approach?
by
WSSpoke36
1 day, 10 hours ago -
Microsoft-Backed Builder.ai Set for Bankruptcy After Cash Seized
by
Alex5723
2 days, 5 hours ago -
Location, location, location
by
Susan Bradley
19 hours, 52 minutes ago -
Cannot get a task to run a restore point
by
CWBillow
2 days, 6 hours ago -
Frustrating search behavior with Outlook
by
MrJimPhelps
1 day, 21 hours ago -
June 2025 Office non-Security Updates
by
PKCano
2 days, 17 hours ago -
Secure Boot Update Fails after KB5058405 Installed
by
SteveIT
20 hours, 12 minutes ago -
Firefox Red Panda Fun Stuff
by
Lars220
2 days, 17 hours ago -
How start headers and page numbers on page 3?
by
Davidhs
3 days, 3 hours ago -
Attack on LexisNexis Risk Solutions exposes data on 300k +
by
Nibbled To Death By Ducks
2 days, 6 hours ago -
Windows 11 Insider Preview build 26200.5622 released to DEV
by
joep517
3 days, 12 hours ago -
Windows 11 Insider Preview build 26120.4230 (24H2) released to BETA
by
joep517
3 days, 12 hours ago -
MS Excel 2019 Now Prompts to Back Up With OneDrive
by
lmacri
3 days, 2 hours ago -
Firefox 139
by
Charlie
2 days, 18 hours ago -
Who knows what?
by
Will Fastie
1 day, 21 hours ago -
My top ten underappreciated features in Office
by
Peter Deegan
3 days, 13 hours ago -
WAU Manager — It’s your computer, you are in charge!
by
Deanna McElveen
1 day, 6 hours ago -
Misbehaving devices
by
Susan Bradley
2 days, 9 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.