Can you post your SQL, so we can see what it looks like? How did you create
the "working" table? Did you copy the structure? Is the "live" database
also Access, or is it SQL Server or some other database?
Have you considered only appending the new records that are not already in
your indexed table? If the old records cannot change in the "live" database,
then all you really need to do is append the new records (assuming that you
have a combination of one or more fields that define a primary key for the
table and that your "live" data table is linked to your "working" database).
The way I would handle this is to create an unmatched query and append the
unmatched records to your working table.
1. Add the "live" table to the query grid
2. Add the "working" table to the grid
3. Join them on the PK fields
4. Modify the properties of the joins to include all records from the
"live" table and only those that match from the "working" table.
5. Select all of the fields from the "live" table and add them to the grid
6. Drag one of the PK fields from the "working" table to the grid. Uncheck
the checkbox and set the Criteria = Null
7. run your query (this should give you all the "new" records)
8. Change the query to an append query and select your "working" table as
9. save the query.
Email address is not valid.
Please reply to newsgroup only.