How do I unlink tables?

R

Riley Walker

I have a table that I have moved from Works. It is linked
to another table so I can't modify it. Any Help would be
wonderful. Riley Walker
 
M

Maggie

I'm not the original requester for help, but I too need to unlink a table. The table was originally formed in FoxPro which I don't have on my new computer and so I'm using the table in Access. I now need to add some new fields, but can't because it appears to be linked to the original FoxPro table which I cannot open!
Help please
Maggie
 
J

John Nurick

Hi Maggie,

First, delete the linked table (this deletes the link, but not the
Foxpro data file, but make sure you have a backup of it anyway). Then
import the data from the Foxpro table. This brings the actual data into
the Access file, which is then independent of the Foxpro file.
 
M

Maggie

Thanks John, I'll give it a go.

Maggie

John Nurick said:
Hi Maggie,

First, delete the linked table (this deletes the link, but not the
Foxpro data file, but make sure you have a backup of it anyway). Then
import the data from the Foxpro table. This brings the actual data into
the Access file, which is then independent of the Foxpro file.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to paste this down? 3
How to have two tables on same line? 1
Treating multiple paragraphs as one 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How to delete cut & repost a table 0
Create a dynamic master file 1

Top