Forum Discussion
Database Properties Sheet
In my Access Database Properties Sheet, on the 'Statistics' TAB, there are 3 filed that are not populated, and I'm not sure why. The Fields are "Last Saved By", "Revision Number", "Total Editing Time...
Interesting. I don't ever remember giving that tab more than a passing glance. It's hard to imagine how one would calculate the total editing time, but it should be possible to write a small function to update the revision number when you decide to change it.
Those properties are somewhat useless unless you write code to manage them yourself. It'll take some additional research on that, but as Arnel said, you can do that with custom VBA. How much effort you put into that, of course, depends on how much value added you believe they will be to your users.
Search for examples of adding custom database properties and managing them.
Thank you, George,
For taking the time to respond.
I am surprised that the Values are NOT automatically updated, or Admin Updatable.
Do you think it is an Access deficiency, and worthy of a Support Ticket?
Or would I be wasting my time?
Regards
Paul
For taking the time to respond.
I am surprised that the Values are NOT automatically updated, or Admin Updatable.
Do you think it is an Access deficiency, and worthy of a Support Ticket?
Or would I be wasting my time?
Regards
Paul
- No, and No and Yes. There are too many serious problems that remain uncorrected after many months or even years. Any resources available for the Access team are going to go there.
Most Access developers have developed their own methods of tracking things like revision numbers and so on.
