> A bit of a long shot, but does anyone have any code that
> will log the name of a user (by NT login details), date
> and time, to appropriatly names fields in a table called
> Log, whenever anyone accesses my database?

>-----Original Message-----
>If you really mean "access", as in link to it from

>retrieve data from it, then no, there's no way.

>If, on the other hand, you want to log who opens your
database, you can
>create a routine that runs when the database is opened
and log the
>information yourself. There's code at
>http://www.mvps.org/access/api/api0008.htm at "The

>the NT login ID. Date and time is the Now() function.

>Check http://www.mvps.org/access/general/gen0040.htm for
how to secure your
>database so that they can't just hold down the Shift key
and open it without
>the startup code running.

>This isn't fool-proof by any stretch of the imagination,
but it may provide
>what you're after.

>--
>Doug Steele, Microsoft Access MVP
>http://I.Am/DougSteele

message

>> A bit of a long shot, but does anyone have any code
that
>> will log the name of a user (by NT login details), date
>> and time, to appropriatly names fields in a table
called
>> Log, whenever anyone accesses my database?

>.