Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Last Date Access Database was Used 1
- Thread starter JohnBates
- Start date
-
1
- #2
I guess it depends upon what you mean by "used"? For instance, if you open an Access database, do nothing, and then close it, it still updates the date last modified.
There are last modified dates for Access objects within the database as well, in case that's what you're after. So, if you just want to see that, you could either manually look in the Object viewer tab.. suddenly I can't remember the name of that.![[blush]](/data/assets/smilies/blush.gif "[blush] [blush]")
Another option - if you want to capture this somewhere - you could use VBA to loop through and capture this value from all the objects, and load that into a table for reference.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
There are last modified dates for Access objects within the database as well, in case that's what you're after. So, if you just want to see that, you could either manually look in the Object viewer tab.. suddenly I can't remember the name of that.
Another option - if you want to capture this somewhere - you could use VBA to loop through and capture this value from all the objects, and load that into a table for reference.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
- Thread starter
- #3
Also... if you ever want to look at the objects in a database to see when they were updated, keep this in mind:
The "Last Update" for an object refers to the structure itself, not necessarily the data contained. So, for instance, if you're looking at tables. If the table hasn't been modified at all in 8 years, but new records were added yesterday, then the table wasn't updated, but it does have new/current data. So in that case, you'd have to look at a date field in the database table, if there is one. Otherwise, you'd have to look at a field relating to when records are added.. I don't remember off-hand if there is such a field, but you can look in VBA in the DAO.TableDefs collection.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
The "Last Update" for an object refers to the structure itself, not necessarily the data contained. So, for instance, if you're looking at tables. If the table hasn't been modified at all in 8 years, but new records were added yesterday, then the table wasn't updated, but it does have new/current data. So in that case, you'd have to look at a date field in the database table, if there is one. Otherwise, you'd have to look at a field relating to when records are added.. I don't remember off-hand if there is such a field, but you can look in VBA in the DAO.TableDefs collection.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
- Status
Similar threads
- Locked
- Question