Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    28

    Unanswered: Why Corrupt records

    Perhaps a stupid question but why do Access databases develop corrupt records or in some cases the whole database?
    For instance if two groups of users are using identical databases at different locations are there any likely reasons why one would have such problems?
    Is this a bug with Access on networks?

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    if they are using the same copy of the mdb and streaming (loading) from the network - this will occurr - more than you would expect.

    If two people share an access data base split the db and put the tables on the server and the front end (forms/reports/queries/macros/modules) on the individual PC's

    exiting access abruptly (pc crash etc) can corrupt the header in the mdb file and cause you to have to run repair or lose data

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    28
    Sorry should have mentioned that the database is split, all the users swear that they didtnt do any thing silly like turning their computers off at the wall.

    Ive been advised that optimistic locking on the network greatly increases any corruption problem and to enshure the latest patches are installed Jet4 SP 6 + Office 2k SP3. It seems that only mdac2.5 and office SP1.3 are installed

    This problem seems to happen most days at the moment so i dont think its a data collision/random network chance type of thing but some flaw in the database?

    Are there any ways of tracking down the cause?

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    1)Determine if this happens from one machine or both
    2)Does the corruption happen at about the same time of day (maybe during a backup?)
    3)Ask users to be more aware of when it might happen (same process)
    4)use jetcomp to repair and comapct all the databases in qusetion
    5)Check to see if users of other apps are experiencing anomalies
    6)Sometimes renaming the making a copy of the mdb and renaming the old one to databaseName_old.mdb will will alleviate the possibility of the mdb being on bad sectorws of the drive

    Consistent corruption means a pattern - you need to identify the pattern
    But I strongly reccommend using jetcomp

  5. #5
    Join Date
    Dec 2003
    Posts
    15

    Question

    IS there any way to identify what user made a problem to the database ?

    Trung - The new member

Posting Permissions

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