Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
In MS Access database, how can I see which records were ...?
In MS Access database, how can I see which records were changed or updated during my last session?
I accidentally updated some records in a membership list, but I did it in the WRONG membership list! I need to find out which records I changed, so I can do it in the correct membership list.
2 Answers
- 1 decade agoFavorite Answer
The other answer is almost right. You can set another field "DateChanged". Every time you edit a record, that field should be updated with Now().
The exact technique for doing this will depend on if you are using a query or SQL statements to do you updating.
If you are using some type of security on the database and you know who logs in, you can also set up a field "LastUser" and populate this with a number or name for the user who last edits a record.
In your case, you have lost the data you changed unless there is a backup somewhere that you can compare the data with and figure out what needs to be restored.
In the future, if it is important to you, implement these changes and you can track additions and changes. Unfortunately you can only track the latest change, not the cumulative changes, unless you set up a transaction file and that gets complicated.
Good Luck!
Source(s): Been there, Done that! - 1 decade ago
As far as I know, there is no way to tell which records were and were not changed. You can create a field in a table called entered date whose default value is =now. This will tell you when a new record is added, but I do not think that you can tell when records have been changed. SOrry.
