Hahn said:
Is it possible, to create a login page using access for
user, and then record down all the changes made by
user, when he/she is in the database, including the
date and time. Help needed.
Yes, if you prepare a "developed application" that is thoroughly and
carefully done, so that users _only_ have access to the database through
your forms. In fact, if you do have such an application, you can even use a
Windows API to obtain the computer logon ID or computer name and use that to
identify -- that would allow you to "stealthily" record the users' actions
without them logging in, so they would not necessarily have to know the
record was/is being kept.
MVP Allen Browne has good information on this subject (audit trail) at
http://allenbrowne.com/AppAudit.html. (And, just for the record, his site is
chock-full of tips, tricks, advice, and traps to avoid -- a "treasure trove"
of information for the Access user and developer.
http://allenbrowne.com is
well worth a visit by anyone who "does access".)
No, if you allow users access to table-view or to create and execute their
own queries, or if you miss some little item that lets a user through to the
tables or queries.
Larry Linson
Microsoft Access MVP
