If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
modifying a linked table?
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? |
#3
|
|||
|
|||
modifying a linked table?
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. |
#4
|
|||
|
|||
modifying a linked table?
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? |
#5
|
|||
|
|||
modifying a linked table?
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. |
#6
|
|||
|
|||
modifying a linked table?
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. |
Thread Tools | |
Display Modes | |
|
|