Re: How to capture last used date/time
- From: Jamie Collins <jamieuka@xxxxxxxxxxxxxx>
- Date: Mon, 20 Aug 2007 07:26:58 -0700
On 20 Aug, 07:08, John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
How can I capture thedate/timeof the last usage of my database?
(either it was last open and closed, or it was last manipulated (record
change))
Access does not record this information. You'll need to create a table to
store thedate/time, and write some (very much non-trivial!) code to write to
that table on every event that you want to track.
When I look at an mdb file in Windows Explorer I see a dates for
'Modified' and 'Accessed' respective. Do you think these could be
used? (I really don't know.)
Jamie.
--
.
- Follow-Ups:
- Re: How to capture last used date/time
- From: John W . Vinson
- Re: How to capture last used date/time
- References:
- How to capture last used date/time
- From: K90267000 via AccessMonster.com
- Re: How to capture last used date/time
- From: John W . Vinson
- How to capture last used date/time
- Prev by Date: Re: Best Practice for tables?
- Next by Date: Re: Crosstab Query
- Previous by thread: Re: How to capture last used date/time
- Next by thread: Re: How to capture last used date/time
- Index(es):