Results 1 to 2 of 2

Thread: Two front ends

  1. #1
    Join Date
    Mar 2004

    Unanswered: Two front ends

    I know it's probably a daft question........

    can i link two front ends to one access db back end, and if i can what happens when two users try and alter the same data?

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Yes. That's really the whole point of having a back end

    What happens will depend on where your back end is hosted (Access or SQL Server) and what your Record Locks settings are. Generally speaking, Access will handle the situation by either locking out the second user who tries to edit the same data or it will pop up a conflict box telling the second user who tries to save the data that the other user's changes will be lost if they continue.
    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