How khow who created or updated a record in access 2007?

L

Lina M. Quitian

How can have user-level security in Access 2007 and know who created or
updated a record for control?
 
T

Tom van Stiphout

On Sat, 18 Jul 2009 14:31:01 -0700, Lina M. Quitian <Lina M.
(e-mail address removed)> wrote:

ULS is an advanced topic; don't go there unless you first download,
study, and fully understand the Access Security FAQ from
microsoft.com.
In A2007 ULS is only available with the MDB format, not with the new
ACCDB format (hint, hint).

To know who created or updated a record you don't need ULS. I would
recommend you use http://www.mvps.org/access/api/api0008.htm to ask
Windows who is logged in, and store that in CreatedBy and ModifiedBy
fields in your table(s).

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Security - Conversion 3
Access 2007 security and the Access 2003 system.mdw file 2
Access 2007 - Security 6
Access 2007 Security/Users/groups etc. 3
Disable Workgroup Security in 2003 DB for 2007 SP 10
Users in Access 2007 2
how to start application in a client with hight livel restriction? 2
Access Automatically Send a notification email once a record is added 0

Top