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

  • Thread starter Thread starter Lina M. Quitian
  • Start date Start date
L

Lina M. Quitian

How can have user-level security in Access 2007 and know who created or
updated a record for control?
 
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

Need Multiple Users/Permissions Suggestions 4
How to prevent users from deleting records? 3
Access 2007 - Security 6
Access 2007 Security - Conversion 3
Who's Online? 5
Create an Audit Trail of Record Changes in a Form for Access 2007 1
Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking? 10
Access 2007 Security/Users/groups etc. 3

Back
Top