Macros, coding and design

How does one best outfit Access2003 so

--

When the .mdb file opens, it writes a =Now() Date to a field in Table?

When the .mdb closes, it writes a =Now() Date to a field in Table?

--

What, I wonder, is MSysObjects hidden table?

--
Jim Shores
on Red Mountain
in Birmingham, Alabama

Jim

If you have a form that is opened when the file opens, you could add event
code to when it opens. If that's the "last" form that closes, you can use
that event, too.

You can create a code module to handle the writes-to-table -- you just need
events (?OnOpen, OnClose?) to trigger that code.

--
Good luck

Jeff Boyce
Access MVP