refresh an imported table without destroying relationships

  • Thread starter Thread starter mg
  • Start date Start date
M

mg

- create table from external odbc data, using an IMPORT instead of a LINK
- the import will allow a lot of read-only reporting to run MUCH faster

how would i go about 'refreshing' the imported data WITHOUT destroying any
relationships to other queries/tables
(i noticed that when i deleted a table by hand that i got a warning message
that relationships would be compromized)
 
Assuming that the relationship is based upon the primary key of the table
being imported, first create an update query to update any records where the
primary key is already there. Next create an append query to add new records.
Last create a delete query to remove any records no longer needed.

However I would first try to speed up the ODBC connection so that users get
the freshest data without all the hassle of doing updates and importing. For
instance have you looked into pass-through queries?
 
Back
Top