Can't overwrite a file in Import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to import a file into Access and have it override an existing file
so I can keep all my queries, tables, and report. Access asks me if I'd like
to overwrite table I say yes and then it says Can't overwrite the table. The
new file has the same # of columns as the old one but not the same number of
records because data has changed. What am I doing wrong?
 
Never mind...it was because I had relationships on the original table. When I
deleted the relationships I could import it. (Trying to learn this on my own
can you tell?)
 
Regi said:
Never mind...it was because I had relationships on the original table. When I
deleted the relationships I could import it. (Trying to learn this on my own
can you tell?)
Click to expand...

I suppose it's too late now, but you might have done this by importing
the table under a new name, *duplicated* the original relationships from
the old version to the new one (so you could be sure you copied all of
them), *then* deleted the old relationships and the old table.

If you later decide the old table contained useful information (and I
certainly hope you made a backup copy of your database file before doing
any of this!), you can import the old table from the backup copy of your
database.
 
Back
Top