Web Development

Ask something
Discussion Locked

Access 2002 Transferdatabase Action

0 helpful
3 replies

by hsackner

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I created a macro in Access 2002 that imports a specific table from one access database to another. The table in question is in a relationship with another table on the second database. The name of the tables are the same in both databases. When importing into the second database, the table is renamed i.e Table1. I cannot delete the second table before importing because of the relationship. How can I import the table , using the same name and maintain the integrity of the database without deleteing the relationship?

3 replies

by haris

MS Access also alows link tables, that is, linking tables from one database to another. Linked tables are accessible in both databases and are updated automatically.

Click File -> Get External Data -> Link tables

by kschaumburg

As you found out, the related fields do not have the same name but the related fields must have the same relationship key unless the primary key is an autonumber. I have found that this will link the tables without compromising the integrity of the databases and you do not have to delete the relationship.

by haris

hi,

If you delete the table before importing the new one it will be violation of the integrity rules. These rules are established for the very purpose that related data is not lost.

Your option is to use UPDATE statements instead of importing the table.

This discussion is closed to new replies.