[AccessD] How to repair corrupt database

Some years I buildt a small script which does that for me.
I used ClickExe, which I think may not be available other than in Germany 
since it uses German words for commands (otherwise I would not mind giving 
it to DBA). Also, it is pretty simple and probably much easier to do with 
some .net or such.
It uses a little Access 97 db to buld ini files.
I use this for an Excel worksheet which I update almost daily.
I keep the last 5 copies as backup.
When I want to open that worksheet, I open the script instead, which opens 
the worksheet for me.
when I close the worksheet, the script checks whether it was updated and 
only if so, it will delete the oldest backup, then shift all the others up 
and copy the newest one into the youngest backup slot.
I am using it for several different worksheets and pick them from alist when 
I open the script.
I planned to use it for Access db development as well, however I have not 
yet extended the script to handle more than one file (need FE and BE at 
least to back up).
I think this idea would be helpfull for making automated backups for Access 
and other files, once put into a better program than this ClickExe, which is 
very cumersome to handle.

Anyway, if somebody likes to start on it  and wants that script, or the 
Access db, no problem, just let me know.

Lembit

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at setel.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, May 30, 2007 6:52 PM
Subject: Re: [AccessD] How to repair corrupt database


>
>
> ...you say it ...but you don't really mean it ...none of us do ...not 
> until
> you automate the backup will it really, really get done ...been there, eh 
> :)
>
> =========I am trying to be more faithful about this. Word recently ate a
> manuscript just as I'd completed it. I hadn't had time to save it to
> removeable and <red checked> I hadn't bothered to do so before. Then, BAM!
> The computer locked up and I had to push the <gasp> button.
>
> Couldn't open the file in Word using either of it's repair options. It was
> toast.
>
> Used WordPad and got the text, but lost the footnotes, etc. It didn't take
> long to rebuild the notes as WordPad displayed underscores in the text in
> lieu of the note numbers and at the end of the file were all the notes'
> text, in order.
>
> Still, it was a pia and a reminder to be more deligent.
>
> Susan H.
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.8.4/825 - Release Date: 30.05.2007 
> 15:03
>
>