Hi,

I have a table in Access that I have imported from an AS400 using a Macro, here is the Macro that I used;

Transfer Type: Import
Database Type: ODBC Database
Database Name: ODBC;DSN=mvxr10;TABLE=DATA09
Object Type: Table
Source: DATA09
Destination: tbl_DATA09
Structure Only: No

Now I have the table with the data I have added relationships so other tables can get data from this table, however in the AS400 this data can be updated, is there away of updating the table data using a macro without having to delete the table.

If I re-run the above Macro it just creates a new table which is no good.

Thanks

Have you thought of using a temp table for the import then append or update to the real table when you activate your macro, therefore all relationships stay in tack and anything that is dependant on the data works in real time.