No Duplicates (overwrite)

[Eric]

The table has the following fields: ID (Primary Key), Date loaded (Default
Now()).

The Database is populated (successfully) by exporting form fields from MS
Word Template into the Access Table. I'm trying to allow the user to export
several times if needed. In the table I would like the ID field to overwrite
the old record, with the new record. Thus No Duplicates, but retaining the
newest record, an Overwrite.

Any help on this idea would be great.

Thanks

 

[pietlinden]

The table has the following fields:  ID (Primary Key), Date loaded (Default
Now()).

The Database is populated (successfully) by exporting form fields from MS
Word Template into the Access Table.  I'm trying to allow the user to export
several times if needed.  In the table I would like the ID field to overwrite
the old record, with the new record.  Thus No Duplicates, but retainingthe
newest record, an Overwrite.

Any help on this idea would be great.

Thanks

use an update query.

UPDATE MyTable
SET MyField = ... new value
WHERE MyField = old Value
AND MyPrimaryKey = PK value;