Making security backups with ado

From: Guillem (keinname_at_eresmas.net)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 14:42:40 +0100

Hi,

In my app I need to make security backups periodically that can be reloaded
into the DB in case of crash/corruption. To do this I'm using the SaveToFile
method provided by ADO. The app controls the date and decides if necessary
to make a copy on file for every table in the database. Until this point all
works fine.

The problem comes when I try to "restore" the DB. I wanted to use
LoadFromFile and then somehow insert all the values in their respective
tables, but at this point it's where I get not through. Methods Post and
UpdateBatch need the record to be "edited" (i.e, modified, inserted or
deleted), so they won't work.

Is there any way to insert all the records at once or do I need to do it
manually? Anyone knows an alternative method? I'll be glad to hear about it.

Thanks for help and best regards
Guillem