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". It is the 'Revision Number' that most interests me, as I want to display this 'property' on ALL my Forms in the Footer. Can you please suggest why this may be occurring?
5 Replies
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- 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.
- are they Custom database Property.
you can manually create them.
you can google for it on how to add user-defined property of the database.- Thank You, Arnel.
I don't think they are "Custom" properties, since they appear on the Database Property Sheet, that I have no control over.
