Results 1 to 4 of 4
  1. #1
    Buakaw is offline Absolute novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    112

    Novice question about multiple users

    Hi,
    Does splitting the db into FE and BE solve the data corruption problem if multiple users were to try to open and modify a DB at the same time?

    If I distribute the FE to users on their local computers and then use a VPN service to enable access to the BE on a server, does this automatically solve this problem?

    I'm not clear if the BE has built in intelligence to lock out the file when it's in use, when another user tries to access it and do some changes.

    Thanks.

  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

  3. #3
    Buakaw is offline Absolute novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    112
    Thank you RuralGuy.

  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
    You're welcome.

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

Similar Threads

  1. Really Novice Question
    By AccessNoob1 in forum Forms
    Replies: 1
    Last Post: 04-07-2011, 09:44 AM
  2. Multiple users & forms question.
    By Bejo25 in forum Database Design
    Replies: 2
    Last Post: 02-03-2011, 08:26 PM
  3. Multiple Users
    By jo15765 in forum Forms
    Replies: 2
    Last Post: 12-03-2010, 09:51 PM
  4. Novice question about using established forms
    By runabout6 in forum Access
    Replies: 2
    Last Post: 08-23-2010, 09:00 PM
  5. Replies: 1
    Last Post: 02-27-2006, 07:46 AM

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