Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    20

    Unanswered: guidelines to set up this multiple user file

    i have one server and 4-5 clients will work on a multi-user database.. how can i design it such that it asks for user name and passwords from the users and recognizes them thru that

    when they make any new record entries.. it puts there names and time and date which they cannot remove

    even partial answer can get me started..

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    As for security, check out this topic:

    http://www.dbforums.com/showthread.php?t=1631687

    It should get you up to speed on at least some of the options.

    As for how to record the date and who is modifying data, just create a field for each, populate those fields in your BeforeUpdate event procedure for each form. Make those controls on the forms Locked = Yes and Enabled = No. That will stop users from modifying the content.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2008
    Posts
    20
    Quote Originally Posted by StarTrekker
    As for security, check out this topic:

    http://www.dbforums.com/showthread.php?t=1631687

    It should get you up to speed on at least some of the options.

    As for how to record the date and who is modifying data, just create a field for each, populate those fields in your BeforeUpdate event procedure for each form. Make those controls on the forms Locked = Yes and Enabled = No. That will stop users from modifying the content.
    how do i do this: populate those fields in your BeforeUpdate event procedure

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Just put in Me.Fieldname = Date() into the VBA for your Before Update event procedure.

    That will handle the date part of it. As for the username thing, it depends greatly on how you have setup your logins.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •