Access 97 and linked tables

[Ticotion]

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

 

[Rick Brandt]

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.

 

[Ticotion]

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

 

[Jerry Whittle]

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;

 

[Jeff Boyce]

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