A way to see when data WITHIN a table has been changed?

  • Thread starter Thread starter tjsmags
  • Start date Start date
T

tjsmags

Is there a way to see when each item within a table has been last edited?
Dummy me saved my Alumni database on BOTH my hard drive of my laptop AND my
server (desktop in basement). I wanted to 'play with' a form without
altering the original, so I saved the entire database at a new location. Now
I have edited data within BOTH databases and I'm trying to figure out which
one has the most current changes within the TABLE of contacts (I made address
changes, but I don't remember which names I altered...I have about 1500
names).

Also, I created some REPORTS in one that I wanted saved in the other
database. Can I just right-click on the form and copy it and then paste it
into the other database that I saved in the different location?
 
Is there a way to see when each item within a table has been last edited?
Click to expand...

Unfortunately no. Access neither knows nor tracks when tables, records or
fields are edited.
Dummy me saved my Alumni database on BOTH my hard drive of my laptop AND my
server (desktop in basement). I wanted to 'play with' a form without
altering the original, so I saved the entire database at a new location. Now
I have edited data within BOTH databases and I'm trying to figure out which
one has the most current changes within the TABLE of contacts (I made address
changes, but I don't remember which names I altered...I have about 1500
names).
Click to expand...

:-{(

Two lessons: 1. Keep good backups. 2. Split your database so that the data
tables are in one mdb file and the forms, reports, etc. in another. This lets
you play with a form without risking data.
Also, I created some REPORTS in one that I wanted saved in the other
database. Can I just right-click on the form and copy it and then paste it
into the other database that I saved in the different location?
Click to expand...

Better would be to open the target database and use File.. Get External Data..
Import.
 
You can add that functionality, but it's not built into Access.

Add a LastUpdatedDtm date field to your table (heck, you can add a
LastUpdatedBy text field as well if you want!)

In the BeforeUpdate event of your form, put code to set the LastUpdatedDtm
field to Now. (You can grab the code from
http://www.mvps.org/access/api/api0008.htm at "The Access Web" to get the
user's network Id so that you can set LastUpdatedBy)
 
Regarding your two lessons, how do I accomplish #2? How do I build forms,
reports, etc and have it grab the data from another file?
 
Back
Top