refresh an imported table without destroying relationships

[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)

 

[Jerry Whittle]

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?

 

[MGFoster]

- 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)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Instead of deleting the TableDef just empty the table (DELETE FROM
tableName) and import the data into the empty table. You could even
import into an already populated table. Depends on your needs. Read
the Access Help article on TransferDatabase Method. (Hint: Open the
Debug window [Ctrl-G] type TransferDatabase. Keep the cursor on the
word and hit the F1 key. The Help article will appear [as long as you
have the Help files installed]).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSacM8IechKqOuFEgEQLgyQCdF1A/fYOpYKBNvXMmIXkJEjAQqGcAn18N
CYb/JdJFWy91xspRn1wesQHQ
=oyWr
-----END PGP SIGNATURE-----