modifying a linked table?

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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ZZX" "Bob.No wrote in message
...
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?

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 wrote:
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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ZZX" "Bob.No wrote in message
...
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?

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 wrote:
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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ZZX" "Bob.No wrote in message
...
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 wrote:
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.