How do I corrupt an mdb intentionally for test purposes

Posted on 2007-10-08
Last Modified: 2012-08-14
I'm creating a process to check for corrupt tables in an MDB on server.  There's no code, just tables.
I would like to corrupt an mdb intentionally for testing.  Has anyone ever done this?
Question by:clarkscott
    LVL 65

    Expert Comment

    by:Jim Horn
    >I would like to corrupt an mdb intentionally for testing.  Has anyone ever done this?
    No.  I get paid to build stable applications, not corrupted ones.

    I imagine that if you open your Access app, then ctrl-alt-delete and end task a few thousand times, that would do it.
    LVL 61

    Assisted Solution

    > Has anyone ever done this?
    No,  I'm just a paid scapegoat when DB's corrupt on their own.

    This link lists ways to avoid corruption:

    A loop to create/delete lots of records in temporary tables to deliberately fragment the database might eventually cause corruption.

    LVL 65

    Assisted Solution

    by:Jim Horn
    Application.CorruptMe True

    Sorry, couldn't help myself there...
    LVL 56

    Accepted Solution


      You guys are really helpfull....


      Open the database with a word processor, then over type some of the characters and save.  Can do the same with a disk/file editor.


    LVL 20

    Author Comment

    Thanks guys....

    Jim Horn... thanks for the suggestion - (CorruptMe = true) but it didn't work..... :-)

    deally, I'd like to have only a  single table (of several) corrupt.

    Corruption the entire mdb won't help me (or perhaps help a little).

    I may create a VB app that opens- ctrl/alt/del - over and over again until something turns ugly.....

    Well.... I'm going to split the points - Jim get some since he made me (probably all of us) laugh.  I needed that today!

    Scott C

    LVL 61

    Expert Comment


    Markus posted this neat question a while ago.  You might enjoy it:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now