General discussion

Locked

Access roe change capture

By andrew.czaja ·
How can I in Access identify all the rows that were changed since the last time I worked with the database?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access roe change capture

by sgt_shultz In reply to Access roe change capture

what version of access?

Collapse -

Access roe change capture

by andrew.czaja In reply to Access roe change capture

The question was auto-closed by TechRepublic

Collapse -

Access roe change capture

by Bob Sellman In reply to Access roe change capture

If this is needed, then the sure way would be to add a date/time column ("Last Change Made") to each table that needs to be tracked. Modify your application so that every time data is added the date/time of the addition is saved with the row of data, and every time the data is changed in a row, the data/time the change(s) is/are made is recorded.

If you know or keep track of the last date/time you worked with the database, then queries could be built to display all rows changed since that date/time.

In addition you might also want to have a table that recorded the latest date/time that changes were made by anybody to anywhere.

Collapse -

Access roe change capture

by andrew.czaja In reply to Access roe change capture

The question was auto-closed by TechRepublic

Collapse -

Access roe change capture

by andrew.czaja In reply to Access roe change capture

Access v 97 and 2000

Collapse -

Access roe change capture

by timfox In reply to Access roe change capture

Another option is to take a copy of the database before you distribute it and setup a comparison query on the data. Yes, this might seem labour intensive, but will provide an absolute picture of all rows changed since your last database copy.

Exactly how labour (and programming) intensive, depends on how (modular and generic) you implement this approach.

But, depending on your usage of this information, Bob's answer with a LastUpdated field is usually the preferred option.

Hope it helps
TimFox

Collapse -

Access roe change capture

by andrew.czaja In reply to Access roe change capture

The question was auto-closed by TechRepublic

Collapse -

Access roe change capture

by andrew.czaja In reply to Access roe change capture

This question was auto closed due to inactivity

Back to Web Development Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums