modifying a linked table?

[ZZX]

Access 2000
I want to add some columns to a table.
When I try to enter design mode I get a warning message saying I cannot
modify a linked table.
When I look at Relationships there are no longer any linkages shown to
that table.
How can I find out where it is linked?

 

[Allen Browne]

Open the table in design view.

Open the Properties box (Alt+Enter.)

The Description property should show you where it is linked from.

Programmatically, you could open the code window Ctrl+G), and enter:
? CurrentDb.TableDefs("Table1").Connect
substituting your table name for Table1.

 

[ZZX]

It is linked to the location from which I copied it ... and the other
files. I was using a 'copy' to test with.
I tried deleting the link shown in the Description ... would not let me.
How do I break the link?

 

[Allen Browne]

To remove the link, just delete the linked table.
(This does not delete it from the back end database.)

Alternatively, you can link it to somewhere else by using the Linked Table
Manager. That's on the Database Tools tab of the ribbon in A2007, or the
Tools menu in previous versions.

 

[ZZX]

I'm really just trying to make it so that it is stand alone (not linked
to anything including the original from which I copied it.

 

[Allen Browne]

So you want a local copy of the table instead of a linked table?

Delete the linked table.

Then import the data from the other database.
In A2007, Import is on the External Data tab of the ribbon.
In previous versions, Get External is on the File menu.