Results 1 to 4 of 4

Thread: Why is my MS Access database often corrupted?

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2019
    Posts
    50

    Why is my MS Access database often corrupted?

    Every time it corrupted I do "compact and repair database" in MS Access. After it is repaired there are some records replaced with other characters (e.g. #####) the whole row of it. I delete the rows with that characters immediately so that it won't affect other records.What are some possible reasons why it is corrupted? Do you have any idea or suggestion about the MS Access database corruption.

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,404

    Re: Why is my MS Access database often corrupted?

    I gave up on MS Access once I tried loading large amounts of data to it quickly it would always corrupt. It seemed to be around handling of large amounts of data
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,429

    Re: Why is my MS Access database often corrupted?

    There are various potential causes, such as:
    • The file is large (probably over 1 GB)
    • The file is being used by multiple users and/or programs at the same time
    • The file is stored on a network, rather than on the machine that is using it
    • It has been a long time since the last "compact and repair" (it should be done reasonably regularly)


    For several of the causes the best option is to move to a different database system, possibly SQL Server or SQLite. Which one(s) are likely to be best for you depend on your usage.

  4. #4
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    2,482

    Re: Why is my MS Access database often corrupted?

    Quote Originally Posted by ronelpisan View Post
    Every time it corrupted I do "compact and repair database" in MS Access. After it is repaired there are some records replaced with other characters (e.g. #####) the whole row of it. I delete the rows with that characters immediately so that it won't affect other records.What are some possible reasons why it is corrupted? Do you have any idea or suggestion about the MS Access database corruption.
    you have some Delete Function that is not closed(Disposed) properly
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width