How do I create a table copy that is not linked?

A

aemAndy

I'm working in a application that I did not create, but I have administrator
priviledges, so let me know if I need to tweak some settings.

The current database uses a fresh upload of data from another functional
area when we create our annual reports. I've already had problems with
people wanting to view historical data on the table that isn't kept.

I wanted to keep the old data around, so I went to the table, did a "save
as" and renamed the table (ex. was tblDataInfo, did a "save as" to keep a
copy as "tblDataInfo2003").

When it saves the table, it saves it as a linked table to the original, so
when I wiped the original table and loaded fresh data, it wiped out what I
had wanted to be the archived data table.

I don't see anything that allows me to "de-link" the tables without
completely removing one from existence.

Why would a "save as" be automatically linked? Or is this something the
original programmer did, and how can I disable this?
 
O

Ofer

You can copy your table to another one with a different name with
docmd.CopyObject ,"NewTableName",acTable,"TableName"
 
A

aemAndy

I'm not just trying to copy, I'm trying to copy without the tables being
linked.

When I do your command, which strikes me as not being all that different
from using the "copy" and "paste" functions, or doing a "save as", it creates
a table that is linked to the original, and I'm still with the problem.

I realize I can just create a table from scratch and create all the same
fields as the original, then populate it using an append query before nuking
the old data.

However, that seems to be a lot of work for something that should only take
a click or two.

What am I, or what are we all missing here?
 
A

aemAndy

I have found that entire database copies are also linked to the originals, so
I have the same problem, but on a much larger scale. Also, that seems pretty
wasteful to copy a 40 MB database to preserve about 500K worth of data.

I appreciate the attempt, though.
 
O

Ofer

When you copy alinked table it paste it as link table
run a make table query based on your table.
 
Top