Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to avoid network crash in Access (Access)

    I would like to know what is the best way to code an Access program when it is saving data back to the tables when multiple users may be doing the same thing (saving data).

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to avoid network crash in Access (Access)

    One option is to have a frontend/backend split, another is to ensure forms use the Snapshot recordset type.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to avoid network crash in Access (Access)

    Are you sure you said what you meant to say, Jeremy? A snapshot recordset can't be edited, so you certainly wouldn't have multiple people entering records if you used one. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to avoid network crash in Access (Access)

    It depends on what exactly is going on. There are various locking options in Access but they won't stop every possible collision. Data is normally written back to Access tables immediately, so could you explain your question further?
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to avoid network crash in Access (Access)

    That most certainly is not what I meant to say <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>. I can't remember what I was thinking, for now I'll blame it on the night shift <img src=/S/yawn.gif border=0 alt=yawn width=15 height=15>. I was sorting out an error on one of my forms (where I needed to change the view to snapshot), and I misread the question.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>The diary of a bad post
    Sorry
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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