Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupts on network (97 SR1)

    Hi,

    How do you run your Access 97 (SR1) databases - from your local hard drive, LAN or WAN (NT 4). There must be many databases in the company where I work (but I have no idea how many).

    Every now and then I hear about a db becoming corrupted. MS discourages db from being run on the WAN (of course, that doesn't stop the users).

    So what have your experinces been with running Access from HD, LAN or WAN? We get more requests for Access for new projects.

    But dealing with the corruptions has been a nightmare.

    TIA,

    Jimmy

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Corrupts on network (97 SR1)

    I always run a split database schema (frontend and backend databases) whether the data will reside on the server or locally. The frontend will always be local.

    Anything that can cause the server to go down will probably leave the database corrupted, if it was open at the time. You'd be surprised how many small, peer-to-peer networks don't have the "server" on a UPS.

    And while Access works fine on a LAN, the overwhelming sentiment I've heard is "Don't use Access on a WAN!".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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