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
|
|||
|
|||
Access 97 and linked tables
Hi
I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I want to unlink the tables so I get a "normal" table. How can this be done in an easy way where I make sure that the queries that use the linked tables are not effected but uses the unlinked tables? Thank you for your help Br Ticotion |
#2
|
|||
|
|||
Access 97 and linked tables
On Fri, 18 Sep 2009 03:20:02 -0700, Ticotion wrote:
Hi I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I want to unlink the tables so I get a "normal" table. How can this be done in an easy way where I make sure that the queries that use the linked tables are not effected but uses the unlinked tables? Thank you for your help Br Ticotion Delete the links (making note of the names) and then use... File Get External Data Import ....to import the tables you were previously linked to. If you give the tables the same names that the links had your app should not behave any differently. BTW, why do you think there is "no reason" for the links? Generally speaking having the tables in a separate file is the better strategy. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Access 97 and linked tables
Hi Rick
What if I don't know where the table is linked? How can I (in access 97) see where the table are linked so i'm able to import the correct table? Br Ticotion "Rick Brandt" wrote: On Fri, 18 Sep 2009 03:20:02 -0700, Ticotion wrote: Hi I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I want to unlink the tables so I get a "normal" table. How can this be done in an easy way where I make sure that the queries that use the linked tables are not effected but uses the unlinked tables? Thank you for your help Br Ticotion Delete the links (making note of the names) and then use... File Get External Data Import ....to import the tables you were previously linked to. If you give the tables the same names that the links had your app should not behave any differently. BTW, why do you think there is "no reason" for the links? Generally speaking having the tables in a separate file is the better strategy. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
Access 97 and linked tables
I believe that this query will work in A97.
SELECT MSysObjects.Name, MSysObjects.Database, MSysObjects.Connect FROM MSysObjects WHERE (((MSysObjects.Type)=6)) ORDER BY "Table", MSysObjects.Name; -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Ticotion" wrote: Hi Rick What if I don't know where the table is linked? How can I (in access 97) see where the table are linked so i'm able to import the correct table? Br Ticotion "Rick Brandt" wrote: On Fri, 18 Sep 2009 03:20:02 -0700, Ticotion wrote: Hi I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I want to unlink the tables so I get a "normal" table. How can this be done in an easy way where I make sure that the queries that use the linked tables are not effected but uses the unlinked tables? Thank you for your help Br Ticotion Delete the links (making note of the names) and then use... File Get External Data Import ....to import the tables you were previously linked to. If you give the tables the same names that the links had your app should not behave any differently. BTW, why do you think there is "no reason" for the links? Generally speaking having the tables in a separate file is the better strategy. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Access 97 and linked tables
Perhaps a confusion of terminology ...
A "linked" table in an Access database is a lot like a query ... it's a view of a table that's elsewhere. Change something in the table and your view (er, linked table) changes. If you "import" a table, you are making a copy of it inside your Access database. Change something in the original table and you do NOT see the change in your imported copy. Regards Jeff Boyce Microsoft Office/Access MVP "Ticotion" wrote in message ... Hi Rick What if I don't know where the table is linked? How can I (in access 97) see where the table are linked so i'm able to import the correct table? Br Ticotion "Rick Brandt" wrote: On Fri, 18 Sep 2009 03:20:02 -0700, Ticotion wrote: Hi I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I want to unlink the tables so I get a "normal" table. How can this be done in an easy way where I make sure that the queries that use the linked tables are not effected but uses the unlinked tables? Thank you for your help Br Ticotion Delete the links (making note of the names) and then use... File Get External Data Import ....to import the tables you were previously linked to. If you give the tables the same names that the links had your app should not behave any differently. BTW, why do you think there is "no reason" for the links? Generally speaking having the tables in a separate file is the better strategy. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|