Re: How to capture last used date/time

On Aug 20, 6:08 pm, John W. Vinson
<jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
in Windows Explorer I see a dates for
'Modified' and 'Accessed' respective. Do you think these could be
used? (I really don't know.)

They're too hair-trigger - the Modified data changes if you open the database,
look at the screen, and close it. I've never found it useful.

Thanks for the reply. I suspected that might be the case.

FWIW the 'forms' approach may have the opposite problem i.e. code not
triggered often enough if the mdb is accessed 'externally' -- which
reminds me, did you say in another thread you have a technique for
ensuring the mdb is only accessed via one application? Thanks again.

Jamie.

--


.

Relevant Pages

  • Re: Q: changing Table in form
    ... "John W. Vinson" wrote: ... because it opens up another window. ... that they pull from a system, create an Excel spreadsheet and email to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form tutorials?
    ... "John W. Vinson" wrote: ... know if anyone can point me to relevant tutorials. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)
  • Re: seeking a field
    ... "John W. Vinson" wrote: ... In design view of... ... headings that match the text content of the field. ...
    (microsoft.public.access.gettingstarted)
  • Re: Hiding dates Query fields
    ... "John W. Vinson" wrote: ... My query selects all the records that I want. ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)
  • Re: Auto update query
    ... "John W. Vinson" wrote: ... Sorry, but that is incorrect. ... address you had previously was wrong, and the new spreadsheet corrects that ...
    (microsoft.public.access.queries)