Is there any way to change a linked table to a regular table

[Guest]

I have built a database with linked tables to a notes database. The problem
is it takes my database nearly an hour to run a query or open a report. Is
there anyway to convert a linked table to a regular table without removing
the table and starting fresh. Because all of my queries and reports are
built and I would hate to have to rebuild them.

 

[gumby]

You could copy the table and then paste it as a new table but only with
structure. Name is slightly different.

Run an append query with the linked table fields and append it into the
new table. Then delete the linked table and rename the new table
exactly same as the prior linked table.

You could also just copy the linked table, paste with structure only,
and give it a slightly different name. Then copy the linked table again
and then paste, only this time, choose append to existing table. Type
in the existing new table name and hit OK.

 

[Joseph Meehan]

I have built a database with linked tables to a notes database. The
problem is it takes my database nearly an hour to run a query or open
a report. Is there anyway to convert a linked table to a regular
table without removing the table and starting fresh. Because all of
my queries and reports are built and I would hate to have to rebuild
them.

Remember that any copying of the information you do and creating a new
table will break the links so you will no longer see any updates to the
original data.

There may be problems with the connection you are using to access the
data or it may be possible to improve the efficiency and speed of the
process with some programming adjustments.