• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1235
  • Last Modified:

How do I corrupt an mdb intentionally for test purposes

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?
0
clarkscott
Asked:
clarkscott
3 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>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.
0
 
mbizupCommented:
> 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:
http://www.databasedev.co.uk/corrupt-database.html

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


0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Application.CorruptMe True

Sorry, couldn't help myself there...
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  You guys are really helpfull....


ClarkScott,

  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.

JimD.

0
 
clarkscottAuthor Commented:
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


0
 
mbizupCommented:
<OT>
Scott,

Markus posted this neat question a while ago.  You might enjoy it:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22763356.html

</OT>
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now