Quetion on Article 209183

  • Thread starter Thread starter kz
  • Start date Start date
Dear Keith:

No records are deleted during appending - by definition.

To show which records will be deleted you should write a SELECT query.
Similarly, in order to show what rows will be added by an append
query, write a SELECT query that gives those rows. For an example of
how to do this, post your append or delete query here.

Note that, if you database is dynamically changing in time, and the
append or delete might be affected by this, you cannot absolutely
predict this. Changes to the data that occur between the time you
perform the SELECT and the APPEND or DELETE may change what will
occur.

In this case, post all the changes to a separate table, then report
them, then post the changes. Even this technique CAN have problems,
but it's better than the simple application of the SELECT.

The only approach that is 100% every time is to stop other operations
momentarily and perform the maintenance you require. This is one
reason databases typically have a scheduled down time on a regular
basis.

How to Delete Duplicate Records from a Table.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;209183&Product=acc2000.

I did this without a problem. But is there any way to
show which records were deleted during appending.
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts
 
INSERT INTO table2
SELECT [table1].*
FROM [table1];
-----Original Message-----
Dear Keith:

No records are deleted during appending - by definition.

To show which records will be deleted you should write a SELECT query.
Similarly, in order to show what rows will be added by an append
query, write a SELECT query that gives those rows. For an example of
how to do this, post your append or delete query here.

Note that, if you database is dynamically changing in time, and the
append or delete might be affected by this, you cannot absolutely
predict this. Changes to the data that occur between the time you
perform the SELECT and the APPEND or DELETE may change what will
occur.

In this case, post all the changes to a separate table, then report
them, then post the changes. Even this technique CAN have problems,
but it's better than the simple application of the SELECT.

The only approach that is 100% every time is to stop other operations
momentarily and perform the maintenance you require. This is one
reason databases typically have a scheduled down time on a regular
basis.
Click to expand...
 
Dear Keith:

And the query that would show what will be inserted is:

SELECT * FROM [table1];

Too simple, isn't it!

INSERT INTO table2
SELECT [table1].*
FROM [table1];
-----Original Message-----
Dear Keith:

No records are deleted during appending - by definition.

To show which records will be deleted you should write a SELECT query.
Similarly, in order to show what rows will be added by an append
query, write a SELECT query that gives those rows. For an example of
how to do this, post your append or delete query here.

Note that, if you database is dynamically changing in time, and the
append or delete might be affected by this, you cannot absolutely
predict this. Changes to the data that occur between the time you
perform the SELECT and the APPEND or DELETE may change what will
occur.

In this case, post all the changes to a separate table, then report
them, then post the changes. Even this technique CAN have problems,
but it's better than the simple application of the SELECT.

The only approach that is 100% every time is to stop other operations
momentarily and perform the maintenance you require. This is one
reason databases typically have a scheduled down time on a regular
basis.
Click to expand...

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts
Click to expand...
 
Back
Top