Unanswered: Query to alter relationship between two tables
I need to keep a Access table data in sync with the Oracle database table. I have created a link table in MS Access for the Oracle table. Now I want to delete the entire records from Access table and insert records from Oracle link table. Since the Access table has relationship with the other tables I am not able to delete the records.
I want to remove the relationship temporarily to delete and insert the new records. Then again I would like to establish the same relationship. This would be a daily batch work for me. So I need SQL Queries to remove and estabilish the relationships in Access. Can anybody help me on this?
EMPNO - PK - NUMBER (This is the reference column to other tables)
EMPNAME - VARCHAR
AGE - NUMBER
EMPDES - VARCHAR
(Table structure is same in both Oracle and Access)