Importing Tables/Missing Relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elena - 18 May 2005 18:16 GMT

We have a template Access Database with all relationships created. Queries
are running off of these relationships. The data is being imported weekly
from other Access and Oracle Databases.

Since upgrading to Office 2003, after importing the tables, the
relationships are missing. It's not all the relationships and it's not the
same relationships every time. This never happened before the upgrade. It
seems to be very random.

We would like to know if anyone knows how to fix this particular error.

The data is being impored from Access 2000, Access 2003 and Oracle 9i
databases.

Thanks in Advance,
Elena

Reply to this Message

Jeff Boyce - 20 May 2005 00:43 GMT

Elena

If you are "importing" the same data (structure) each time, why re-import
the tables?

If you are updating existing data, use an update query. If you are
"flushing & reloading", use delete and append queries.

Or, is there a reason you need to "load" at all -- if you can link to the
other tables, what are you gaining by loading?

Good luck

Jeff Boyce
<Access MVP>

> We have a template Access Database with all relationships created.
> Queries
[quoted text clipped - 15 lines]
> Thanks in Advance,
> Elena

Reply to this Message