Corrupting an Access97 database

[ag]

Hi,<br>
<br>
Strange but true, I want to be able to corrupt an Access 97 MDB. It's not so strange really, I'm testing a VB application that needs to be able repair a database file automatically at login. In all the years I've been using Acecss, I've hit a number of corruptions but can I reproduce one intentionally...no way.<br>
<br>
I have tried everything....even editing the MDB/LDB files which whilst it produces the symptoms, obviously won't repair....<br>
<br>
Any ideas anyone?<br>
<br>
TIA<br>
<br>
Andrew<br>

 

[culshaja]

Try either adding a new index or restructuring one, or doing a msaaive update and within the process of executingthe changes kill the process - if your lucky it should corrupt the database as theindexes get out of sync with the data in the tables. This is the usual corruption that I get.<br>
<br>
James

 

[ag]

hi,<br>
<br>
Thanks for that....I managed it in the end!<br>
<br>
ag