Results 1 to 6 of 6
  1. #1
    Jamescdawson is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2012
    Location
    South Wales, UK
    Posts
    98

    Logging activity on my database

    I have a database which services about 8 users with a variety of user/access requirments. (Access 2010) Some users fear that other users might change/modify the data that has alread been entered. (You may recognise the sceanario.... "That's not what I entered - Someone must have changed it after I entered it because I don't make mistakes like that")

    Therefore, I would ideally like to lock specific fields and allow only specific users to modify these fields whilst everyone else should be able to view them, but on reviewing the forum and other references, this looks like it may be quite challenging.... I think I would need to create a special form for the lower level uses restricting their ability to modify certain fields.... Is there a simple and systematic way to do this ?

    Alternatively (or perhaps additionally) is there some way to create an on-going log which records who (or which windows log-in) made changes to the database and when ??



    Thanks for your consideration

    Best Regards

    Jimbo

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    MVP Allen Browne has covered both of these situations nicely:
    http://allenbrowne.com/ser-15.html
    http://allenbrowne.com/AppAudit.html

  3. #3
    Jamescdawson is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2012
    Location
    South Wales, UK
    Posts
    98
    RuralGuy,

    Thanks for the pointer.... I reckon these will do the trick..... However, I wonder if you might help me with two small items in that article....

    1.) How do I turn on the "Confirmation Options" as mentioned bullet No.5 in the first section of the article..... Athough there is a note at the top regarding 2010, I don't understand how that relates to this instruction or where I put find this switch

    ... and ...

    2.) Under "Steps" on Page 3 of the article, Step One describes how to open the code window in the older vesions of Access but not the 2010 version. I'm not sure how to interpret this in 2010. neither am I aware of a "General Declarations" section. I can of course access the properties sheet in 2010 and the individual elements therein e.g. "OnDelete" or "AfterDelConfirm" so my question is... Where do I lodge the "Dim bWasNewRecord As Boolean" instruction?...

    Thanks in anticipation

    Best Regards

    James

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I have to go to a meeting right now but I'll respond when I get back. Sorry.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Jamescdawson View Post
    1.) How do I turn on the "Confirmation Options" as mentioned bullet No.5 in the first section of the article..... Athough there is a note at the top regarding 2010, I don't understand how that relates to this instruction or where I put find this switch
    It is under File>Options>Client Settings>Editing>Confirm(5th item)

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by Jamescdawson View Post
    2.) Under "Steps" on Page 3 of the article, Step One describes how to open the code window in the older vesions of Access but not the 2010 version. I'm not sure how to interpret this in 2010. neither am I aware of a "General Declarations" section. I can of course access the properties sheet in 2010 and the individual elements therein e.g. "OnDelete" or "AfterDelConfirm" so my question is... Where do I lodge the "Dim bWasNewRecord As Boolean" instruction?...

    Thanks in anticipation

    Best Regards

    James
    You create a new module in ac2010 by going to the Create Ribbon and on the right is a "Module" to press.

    The "General Declarations" section of *any* module is after:
    Option Compare Database
    Option Explicit

    Dim bWasNewRecord As Boolean

    ...and before any procedures or functions are defined.
    Public Function Foo()...

    These variables are then "Public" to the module and can be referenced by any procedure in *that* module.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. accdb database logging in as Admin by default
    By teja in forum Database Design
    Replies: 1
    Last Post: 03-19-2012, 06:42 AM
  2. Logging Changes
    By nichmeg in forum Programming
    Replies: 0
    Last Post: 12-06-2011, 02:47 PM
  3. Add activity for each customer
    By nostr4d4m in forum Queries
    Replies: 11
    Last Post: 03-25-2011, 09:08 AM
  4. No activity in last 30 days
    By CMLS in forum Queries
    Replies: 4
    Last Post: 03-18-2011, 11:26 AM
  5. Logging In
    By runtest in forum Programming
    Replies: 1
    Last Post: 02-21-2010, 11:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums