Export Table to db

[Dave]

Hi All
I develop my updates in a copy of the database and then Export the data
tables from the working database so the new work is already included. Since
making some upgrades, I wanted to export from the working db to the updated
one and Access won't allow it. The error is "Access can't over-write the
existing table because it is participating in one or more relationships."
How do I get around this? I deleted the established relationships from the
relationship window, but other queries have similar relationships
established. Is there a better way to update the db?
Thank you all for your help.

 

[Jackie L]

You must still have a relationship (other than in the queries). Try clicking
on Relationships - Show All to make sure it is removed.

I do question the process you are going through.
What about linking to the database that is receiving the updates and using
append queries to add to those tables? Exporting tables to other databases
does not seem like the best way to handle this.

Hope this helps.

 

[Dave]

Hi Jackie
"Show All" displays the relationships I deleted from the window. Is this
because it really isn't deleted or is it taking the relationship from the 2
new queries I created (which have those relationships established in them as
well)?

Appending the database tables was the only other thing I could think of to
do. My only concern was corrupting the data with an append query because a
couple of the tables index use AutoNumber. You don't believe exporting the
current working tables to the newly updated copy is a good method?

Appreciate the advise.
Dave

 

[Jackie L]

Dave,

When deleting a relationship, you need to make sure you delete the join line
first and then the table. If you just delete the table, the relationship is
not actually gone.
It does not have anything to do with relationships in the queries.

In regard to the exporting versus appending, I do not know exactly what you
have gone through or what you are trying to accomplish. You did however, use
the dredded "A" word (autonumber). If you are just trying to have a program
use data from another database, what about links? Your data should be split
from the application anyway.

Jackie